Forum Discussion
Difference in values from the same column in the same table based on
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 meausreI hope It may resolves your issue!
Community ChampionHi 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!
