RANKX Measure always 1

[_chris_]

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 want to create a Rank measure:

SumUmsatz := CALCULATE(SUM(vbasFASTEC_WaWiVKBelegpositionen[Umsatz]))

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

Now my table gives me the following result:

Actually I expected to get the yearly rank of Umsatz.

What am I doing wrong?

Thx Christian 

[lbendlin]

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

[_chris_]

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]

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

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 · Accepted solution]

@_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]

SumUmsatz := sum(vbasFASTEC_WaWiVKBelegpositionen[Umsatz]) 

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