How Do I Get RANKX Working

[Anonymous]

Hello

I am having issue with getting the RANKX to work, it might be that each year is a consolidation of multiple transaction.

Ranked =
RANKX('Daily Metric',
'Daily Metric'[Total Actual])

How do i fix this?

Cheers

[Anonymous]

Thanks its working, just had to change it to:

RANKX(ALLSELECTED('Date'[YearName]),

'Daily Metric'[Total Actual])

[amitchandak · Accepted solution]

@Anonymous , Try like

Ranked =
RANKX(allselected('Daily Metric'[Year]) ,'Daily Metric'[Total Actual])

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

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