Forum Discussion
ranking
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
Anonymous , 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=25627sPower BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA
1 Reply
Anonymous , 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=25627sPower BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA