Forum Discussion
Measure total is displayed incorrectly
I'm having 4 measures
1. Flag with 'Yes' or 'No' values based on some conditions
2. Amount_M , Which is the sum of another column amount:
CALCULATE(ABS(SUM('Master'[Amount])))
3. Positive vals=
if([Flag]="Yes",SUMX(Table,[Amount_M]),0)
4. Negative vals=
if([Flag]="No",SUMX(Table,[Amount_M]),0)
now the total of both Positive vals and Negative vals is coming incorrectly. What can be done
2 Replies
- Greg_Deckler
Community Champion
First, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Second, This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
