Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Ranking

Hi.

 

I have this table: 

 

I have the measure: 

Total materiale = CALCULATE(COUNT(Activecampaign[*Materiale]))
 
and I tried to do the ranking with this eqaution:
Ranking = RANKX(ALL(Activecampaign), [Total materiale],,DESC)
 
But it returns only 1...
 
What should I do differently?
 
Best regards,
Lisa 
 
  • HI,

    Try doing this

     

    Ranking = RANKX(ALL(Activecampaign[*Materiale]), [Total materiale],,DESC)

     

    Marco

1 Reply

  • menglaro78's avatar
    menglaro78
    Microsoft Employee

    HI,

    Try doing this

     

    Ranking = RANKX(ALL(Activecampaign[*Materiale]), [Total materiale],,DESC)

     

    Marco