Forum Discussion
TableSorter Custom Power BI Visual - Rankings
Tsoltvedt , Not sure on table sorter, But we usually use rank measure for rank
examples
Rank Discount % = RANKX(all("Item"[Category]),[Discount %],,DESC,Dense)
Rank Discount % (Brand) = RANKX(all("Item"[Brand]),[Discount %],,DESC,Dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
Many thanks for the reply. I have tried RANX but the challenge I'm facing is that I need the rank to be calculated based on the particualar configuration chosen in the slicer. The table contains data across different years/quarters and different categories. What I'm looking to do is get a rank that applies to the specific category and year/quarter selected.
Table Sorter seems to do this, but as I mentioned in the initial post and reply there is a bug that means that the selection defaults away from the Dense ranking mode.