Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ranking based on multiple criteria

Hi All,    I have the following data:  Name Status DateTime A 1 2020/01/05 17:59:57 A 1 2020/01/05 17:59:59 A 2 2020/01/05 17:59:35 B 1 2020/01/05 17:59:54 B 1 2020/0...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You may create rank using Column or measure like DAX below.

 

Column1= RANKX(FILTER(ALLSELECTED(Table1),Table1[Name]=EARLIER(Table1[Name])&&Table1[Status]=1),Table1[Date],,DESC, Dense)
 
Measure1= RANKX(FILTER(ALLSELECTED(Table1),Table1[Name]=MAX(Table1[Name])&&Table1[Status]=1),MAX(Table1[Date]),,DESC, Dense)

 

You can go through the link https://docs.microsoft.com/zh-cn/dax/rankx-function-dax to learn more about the RANKX .

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.