Forum Discussion

1 Reply

  • 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