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
)
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

kandre123 ,

 

Could you please share some sample data and give the expected result?

 

Regards,

Jimmy Tao

    • 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