DAX Measure to Calculate Difference.

[bob57]

Hello,

I need a DAX measure that will produce the column, DiffFromBlue, shown in Table 2. The column must display the difference in the Rating column from Tee Blue. For example, for Pebble Beach from the Black tee the difference is 2.9 or the Black Tee Rating (75.5) minus the Blue Tee Rating (72.6). Another example: for Spyglass Hill from the White tee the difference is -1.9 or the White Tee Rating (71.7) minus the Blue Tee Rating (73.6).

On the surface, this problem seems simple enough, but the solution escapes me.

Thank you for your time.

[bob57]

That did the trick! Thank you so much,

Bob

[tackytechtom · Accepted solution]

Hi @bob57 ,

If this is the outcome you wish for...

... then I have a possible solution for you:

DiffFromBlue = 
VAR _valueBlue = 
CALCULATE (
    MAX ( TeaTable[Rating] ),
    ALLEXCEPT ( 'TeaTable', 'TeaTable'[CourseName] ),
    TeaTable[Tee] = "Blue"
)

RETURN
MAX ( TeaTable[Rating] ) - _valueBlue

Hope this helps! 🙂

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom