topic Re: DAX Measure to Calculate Difference. in DAX Commands and Tips

DAX Measure to Calculate Difference.

bob57 — Thu, 03 Feb 2022 20:13:50 GMT

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.

Re: DAX Measure to Calculate Difference.

tackytechtom — Thu, 03 Feb 2022 20:43:42 GMT

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

Re: DAX Measure to Calculate Difference.

bob57 — Thu, 03 Feb 2022 21:00:11 GMT

That did the trick! Thank you so much,

Bob