Difference in values from the same column in the same table based on

[Mansoer09]

Hi All

I have data stored in a table called "Data", i need to calculate the difference on a column called "Amount (GC)" based on another column called Source, the data in Source could either be METS or TMS in the source column. 

So as an example the difference here would be  = (METS)9 990 658.3 - (TMS)6 834 819 = 3 155 839

[Uzi2019 · Accepted solution]

Hi @Mansoer09 
You need to create seperate measures for METS and TMS and do the minus operation
or create this dax under single measure

Final =
 var METS GC= calculate( sum(amount), Source= "METS")
var TMS= calculate (Sum(amount), Source= "TMS")
var Difference = [METS GC] - [TMS]

Return Difference

Or create seperate measure for individual calculation

1) METS measure
2)TMS measure
3) Diff meausre

I hope It may resolves your issue!

[Mansoer09]

Thanks Uzi, will give it a go

[Uzi2019]

Hi @Mansoer09 
If my post/solution helps you. You can Accept as solution so other may find it quickly.