ranking

[hongyuliu]

Hi there,

I want to add a column to rank my customer according to total value of >60 days AR. Please advise how to write the formula. Thank you

Below is the sample of my data

[amitchandak · Accepted solution]

@hongyuliu , Create a measure with Filter > 60 days

then create rank measure

Rankx(Allselected(Table[Customer]), [GT 60 Measure],,desc,dense)

In case you want other columns, add them to allselected

Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627s

Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA