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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

The measure. Throw in an ALL() somewhere.

 

Read up on row context and filter context. It will be confusing at first but it is fundamental to enjoying DAX in the long run.

_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.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

     

    SumUmsatz := sum(vbasFASTEC_WaWiVKBelegpositionen[Umsatz]) 

Rank Test := RANKX(all(vbasFASTEC_WaWiVKBelegpositionen), [SumUmsatz])