Forum Discussion

kandre123's avatar
kandre123
Advocate I
6 years ago
Solved

Ranking

Hi all,   I am trying to do a combined ranking based on two calculated measures: EBITDA margin and CAGR. where 1 is the combined highest score of both. Problem is that i can't use measures in a RAN...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    kandre123 you RANK measure should be either use ALLSELECTED(DimSelskaper[Juridisk selskapsnavn]) because you are using column in the table or you should do ALLSELECTED( DimSelskaper )

     

    RankX EBITDA Margin = 
RANKX(
ALLSELECTED(DimSelskaper[Juridisk selskapsnavn]),
CALCULATE([EBITDA Margin]),,
DESC,
Dense
)
parry2k's avatar
parry2k
Super User
6 years ago

kandre123 you RANK measure should be either use ALLSELECTED(DimSelskaper[Juridisk selskapsnavn]) because you are using column in the table or you should do ALLSELECTED( DimSelskaper )

 

RankX EBITDA Margin = 
RANKX(
ALLSELECTED(DimSelskaper[Juridisk selskapsnavn]),
CALCULATE([EBITDA Margin]),,
DESC,
Dense
)
kandre123's avatar
kandre123
Advocate I
6 years ago

thanks. That worked out