Forum Discussion
Solved
Dynamic RANKX with Slicer and 2 Groups
I'm using a table to display metrics for all [Work_Type] for the employee and date range selected from a slicer. For example, if selecting Employee A and date range 1/2/2022 and 1/2/2022, the table w...
Hi CamIAm88 ,
You can share the pbix file by onedrive then post the link or you can share the screenshot.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserCamIAm88 , why rank is 6,6, 3
Rank can be done like. assume [Hour Worked] is measure in which you want rank
Rankx(All(Table[Work_Type]) , [Hour Worked], ,desc,dense)
or
Rankx(Allselected(Table[Work_Type]) , [Hour Worked], ,desc,dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns