how to take two values from a column and subtract them from each other

[PowerBINoob12]

Hi

i'm trying to figure out how to subtract the two values in the column "count" from each other.

This is a filtered table so I cant pivot it etc.

hoping there is some code that will put each value in a variable and then I can subtract them after.

any advise would be greatly appreciated.

[PowerBINoob12]

Thank you so much for your help - this was slowly draining the life from me 🙂

[jdbuchanan71 · Accepted solution]

@PowerBINoob12 

You can write a measure to calculate each amount then subtract the measures.

Total Count = CALCULATE ( SUM ( 'YourTable'[Count] ), 'YourTable'[Metric] = "Grand Total" )

Manual Count = CALCULATE ( SUM ( 'YourTable'[Count] ), 'YourTable'[Metric] = "Manual" )

Difference = [Total Count] - [Manual Count]