Forum Discussion

lnpapin's avatar
lnpapin
Icon for Helper I rankHelper I
6 years ago
Solved

RankX not working when you add client description

HI, I have this test data:  When I write this mesure i get this result which is perfect: But when i whant to add the name (Nom in french) of the client i get this result with all 1 inste...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    lnpapin ,

     

    Try this measure:

     

    RANK1 = RANKX(ALLSELECTED('Table'[Client]; 'Table'[Nom]); CALCULATE(SUM('Table'[Valeur])))
     
lnpapin's avatar
lnpapin
Icon for Helper I rankHelper I
6 years ago

OK and if i want to see the rank of the total value how can i do that?

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

lnpapin ,

 

Try this measure:

 

RANK1 = RANKX(ALLSELECTED('Table'[Client]; 'Table'[Nom]); CALCULATE(SUM('Table'[Valeur])))
 
  • lnpapin's avatar
    lnpapin
    Icon for Helper I rankHelper I
    6 years ago

    Thanks you so much! it works