RANKX not operating on correct level

Hi Anonymous 

You need to first add a separate measure 

Sum Users = SUM('All Web Site Data'[New Users])

 

then add another measure

Rank = RANKX(ALL('All Web Site Data'), [Sum Users] )

 

By the way selimovd we use CALCULATE only when we need to filter an expression.

 

 

Hey Anonymous ,

in this case you have to follow 2 things:

1. Make the whole table available with ALL()

2. Use context transition for the measure itself with CALCULATE

So the following measure gives you the rank:

Rank New User =
RANKX(
    ALL( 'All Web Site Data' ),
    CALCULATE( SUM( 'All Web Site Data'[New Users] ) )
)

Let me know if that works and if you can transition that to your original problem.