Forum Discussion

kandre123's avatar
kandre123
Icon for Advocate I rankAdvocate 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
Icon for Community Support rankCommunity Support
6 years ago

kandre123 ,

 

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

 

Regards,

Jimmy Tao

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper 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
      Icon for Advocate I rankAdvocate I
      6 years ago

      thanks. That worked out