Forum Discussion
Top 10,20,30 Values using Dynamic Slicer
Hi Ashish_kumar12 ,
Here are the steps you can follow：
1. Create a table.
2. Create measure.
Measure_rank = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Revenue])),,DESC)Measure_flag = var _top=SELECTEDVALUE(Slice[Top]) return IF([Measure_rank]<=_top,1,0)3. Set Sort by-[ Measure_rank] and Sort ascending.
4. Take the [Top] column of the Slice table as the slicer, put measure[Measure_flag] into the Filter, and set is=1, apply filter.
5. Result.
When 10 is selected, the top 10 data will be displayed:
When 20 is selected, the top 20 data will be displayed:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ashish_kumar12 ,
Here are the steps you can follow：
1. Create a table.
2. Create calculated column
rank = RANKX('Table','Table'[Revenue],,DESC)3. Create measure.
Flag =
var _top=SELECTEDVALUE(Slice[Top])
return
IF(MAX('Table'[rank])<=_top,1,0)4. Set Sort by-rank and Sort ascending.
5. Take the [Top] column of the Slice table as the slicer, put measure[Flag] into the Filter, and set is=1, apply filter.
6. Result.
When 10 is selected, the top 10 data will be displayed:
When 20 is selected, the top 20 data will be displayed:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liu,
Thank you so much for your response .
I tried the same measures which you have suggested and i got this error:
Also when i checked my Rank measure i got the same value in each row "1"