Hi Survivor, Hope you're doing well. Please upload other informative videos as it is very helpful. I proposed this to my client and he just loved it the way I put this in the dashboard. Request you to please upload more such videos.
Nice video . An alternative approach that does not need 1 or 0 as a filter , as follows: CALCULATE ( [Totalsales], KEEPFILTERS ( TOPN ( , ALL ( Products[Product category] ), [Totalsales], DESC ) ) )
I am just getting in to Power BI and watched your video. Very informative and easy way to apply "functional" TopN filtering. I noticed that your SelectedTopN measure (to default to 3 if nothing was selected) was not applied to anything. How do you apply to the filter (or the results)? Thanks in advance.