Forum Discussion
Subtracting two measures
Hello everyone. I have a simple question that keeps haunting me. I have 2 columns with Liablities and Receivables and I created formulas to sum it and then subtract. Liablities Measure = SUMX(Ta...
Anonymous - Tough to say with information provided, but in general, simpler is better. I would stick with
Result = Receivables Measure - Liablities Measure
Unless there is some reason not to, like a measures total problem.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
I don't think your SUMX is a good idea there and your CALCULATE is useless because you are not switching context. So, it does 100% nothing.