Forum Discussion
Top N selection based on filter
- 7 years ago
hi, Anonymous
First, you should know that calculated column and calculate table can't be affected by any slicer. you could create a measure instead of column.
Notice:
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:
https://community.powerbi.com/t5/Desktop/Different-between-calculated-column-and-measure-Using-SUM/t...
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/Second, based on your measure, you could add a what if parameter as a slicer.
Then add a measure
TopN = IF([Rank]<=[Parameter Value],[Rank])
Here is a simple sample pbix file, please try it.By the way, your measureRank = RANKX(ALL(carrier_attributes),SUM(carrier_attributes[Call Limit]),,DESC)
is wrong, if this rank measure could meet you.Rank = RANKX(ALLSELECTED(carrier_attributes),CALCULATE(SUM(carrier_attributes[Call Limit])),,DESC)
Best Regards,
Lin
hi, Anonymous
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin