Measures with and without Variables result in different values

[Anonymous]

When a variable is used, ranking does not seem to function properly.

Can someone explain me what’s going on? Please see the screenshot below.

[Jihwan_Kim]

Hi, @Anonymous 

In my opinion,

The Third one:

when a VAR is created inside a measure for creating a number, the result of VAR inside the measure is fixed, which means it always shows one number.

The second one:

I think you can put CALCULATE function inside your second measure, which looks something like below.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]

Thanks for that ... yeah it worked .. but there must be a way to get around using Variables I believe ?

[Jihwan_Kim]

Hi, @Anonymous 

Thank you for your feedback.

It might be helpful for me if I can understand the reason why you want to use VAR inside the measure.

At this moment, what I can think of is, creating a table by using VAR, not creating a number by using VAR. For instance, like the below.

Rank by Rev V3 =
VAR newtable =
SUMMARIZE ( ALL ( 'Table' ), 'Table'[item] )
RETURN
RANKX ( newtable, CALCULATE ( SUM ( 'Table'[rev] ) ) )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak]

@Anonymous , put a calculate in second one and try

calculate(Sum(Sample_data[turnover]))

[Anonymous]

I have already tried it all and it is not working