Solved: Chart

aishak12 · ‎07-27-2022

All,

Thanks

jdbuchanan71 · ‎07-27-2022

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

View solution in original post

jdbuchanan71 · ‎07-27-2022

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