Forum Discussion
Helper IIIDynamic Rank Analysis Top 5 based on different measures
Since field value is dynamic and it changes by selection, you would not be able to sort for all. Let's say, you sort this by Unit Sold, it will sort but when change to other metric measure say revenue, sorting will change.
So to fix it, you need to use a column which is fixed. In this case Dynamic Rank could be used. See image below:If you don't want to show DynamicRank, you can do a little trick and formating. See image where is actually DynamicRank measure present but you would not be able to see it.
This way I acheived sorting as well as maintained visual requirement.
To acheive this, just change name in the value section of DynamicRank by double clicking to single space. change font color to white. Re adjust column width.
Hope this helps!!If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Super Userhello aAmirkHan
is it possible to use filter pane?
additionally, you might want to use HASONEVALUE() if you want to show 5 top item when selecting the slicer and show all value when no slicer is selected.
Values =
var _Total = CALCULATE(SUM('Table'[Value]),ALL('Table'))
Return
IF(
HASONEVALUE('Table'[Category]),
SUM('Table'[Value]),
_Total
)