Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

RANKX Measure

Hi to everyone!   I'm stuck with a RANKX measure that ranks always in 1 position. Hope somebody can help me with this.   As you can see, I have a matrix opened by "Grupo". I need to rank ea...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi everyone!

     

    Happy to say that is know working, and ashamed after discovering the problem.

     

    The "Grupo" shown in the matrix, is from the facts table, not from the table "GruposIMS". I just changed the dimension of the matrix and the RANKX measure started to show real values.

     

    Thanks for the help.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Please try this

 

Ranking Grupos =
RANKX (
    ALLSELECTED ( 'GruposIMS' ),
    CALCULATE ( VALUES ( 'Medidas VentasIMS'[Ventas IMS] ) )
)

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Zubair_Muhammad.

 

VALUES does not work with measures. It only works when calling a column of a table.

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Anonymous

     

    My aplogies. I thought 

     

    'Medidas VentasIMS'[Ventas IMS]

     

    is a calculated column