Forum Discussion

jdbuchanan71's avatar
jdbuchanan71
Super User
4 years ago

You could do it like this.

Diff Amount =
VAR _A =
    CALCULATE ( SUM ( 'YourTable'[Column 2] ), 'YourTable'[Column Name] = "A" )
VAR _B =
    CALCULATE ( SUM ( 'YourTable'[Column 2] ), 'YourTable'[Column Name] = "B" )
RETURN
    _B - _A