Forum Discussion
Rank x
Hi , I'm struggling with a rankx Dax calculation that would rank all deivces assoicated with a specific stores name , Imagine i have 30 stores with hundreds of devices But i only want to ra...
JamesBurke How about this?
Rank =
IF( LEFT('Emporia Devices'[Device Name],2) = "KP",
RANKX(
FILTER( ALL('Emporia Devices'),
LEFT('Emporia Devices'[Device Name],2) = "KP" ),
CALCULATE(SUM('Emporia Device Usage'[Usages KWH])),, DESC ),
BLANK()
)
CALCULATE(RANKX(
ALL('Emporia Devices'[Device name KP]), // NOT ALLSELECTED
[Total Kwh])
)
I've made conditonal column and use the above Measure , is there a simple way to not include blanks in the rankings ?
thanks !