Forum Discussion

_chris_'s avatar
_chris_
Icon for Helper III rankHelper III
6 years ago
Solved

RANKX Measure always 1

Hi,   this question probably was asked many times  but still I do not get it:   There is a table having ~200.000 lines.   Relevant columns are Date, Customer, Revenue (=Umsatz) etc.   Now I w...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    _chris_ 
    There are some differences of using RANKX() in a calculated column and a measure.

     

    Calculated Column:

     

    Column = RANKX('vbasFASTEC_WaWiVKBelegpositionen',[Umsatz],,DESC,Dense)

     

    Measure:

     

    Measure = RANKX(ALL('vbasFASTEC_WaWiVKBelegpositionen'),CALCULATE(SUM([Umsatz])),,DESC,Dense)

     

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

_chris_'s avatar
_chris_
Icon for Helper III rankHelper III
6 years ago

That´s what I also had tried before:

 

RANKX(ALL(vbasFASTEC_WaWiVKBelegpositionen), [SumUmsatz])

 

But I still get the same result.

 

Yesterday I looked some videos about DAX theory as I agree it is important to understand the basics. Actually, I was of the opinion to have understood it... 

 

Even if I add the Id column to the table (the data is not aggregated anymore) the rank is always 1...

Anonymous's avatar
Anonymous
Not applicable
6 years ago

_chris_ 
There are some differences of using RANKX() in a calculated column and a measure.

 

Calculated Column:

 

Column = RANKX('vbasFASTEC_WaWiVKBelegpositionen',[Umsatz],,DESC,Dense)

 

Measure:

 

Measure = RANKX(ALL('vbasFASTEC_WaWiVKBelegpositionen'),CALCULATE(SUM([Umsatz])),,DESC,Dense)

 

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.