Forum Discussion

xtremus's avatar
xtremus
New Member
4 years ago
Solved

Ranking based on a complex Measure

Hello comunity, I'm needing help to create a ranking measure based on another measure that calculates data from several tables.   The report I'm working on have at least 9 different tables all cone...
KPI Ranking
Measures
RANKX
  • xtremus's avatar
    xtremus
    4 years ago

    Hello again community. 

     

    While writting this post and giving it a depper though I figured that to work properly the performance measure and the ranking needed to be located in the 'VendorsTable' and not in the 'Table1' don't know exactly why but the ranking is working properly now. The DAX sentence I ended up using is:

     

    Ranking = RANKX(ALLSELECTED('VendorsTable'),[Performance])
     
    Hope this helps anyone in a similar situation.
xtremus's avatar
xtremus
New Member
4 years ago

Hello again community. 

 

While writting this post and giving it a depper though I figured that to work properly the performance measure and the ranking needed to be located in the 'VendorsTable' and not in the 'Table1' don't know exactly why but the ranking is working properly now. The DAX sentence I ended up using is:

 

Ranking = RANKX(ALLSELECTED('VendorsTable'),[Performance])
 
Hope this helps anyone in a similar situation.