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

Examine your filter context and adjust as needed with a modifier.

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

    This was a very quick response. Thx for this.

     

    However, I do not understand what you mean? I need to adjust the measure itself or in the visual?

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