Forum Discussion
adnanarain
Helper V
Helper VRank Measure with ID and Date
Hi All, Below is the sample data: ID Date Quantity 1 01/01/20 2 1 01/02/20 3 1 01/03/20 1 2 01/01/20 3 2 01/02/20 7 2 01/03/20 ...
Try this one:
Measure = RANKX(FILTER(ALLSELECTED('Table'),[ID]=MAX('Table'[ID])),CALCULATE(SUM([Date])),,ASC,Dense)Paul Zheng _ Community Support Team
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 Useradnanarain , try like
rankx(allselected(Table[Date]), calculate(sum(Table[Quantity])),,desc,dense)
Please find the attached file after the signature.
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
adnanarainHelper V
Helper Vamitchandak This is what I want.
Try this one:
Measure = RANKX(FILTER(ALLSELECTED('Table'),[ID]=MAX('Table'[ID])),CALCULATE(SUM([Date])),,ASC,Dense)Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.