Forum Discussion
Wrong total amount but correct for each row
Hello, We are experiencing difficulties with calculating the total Cost + a percentage. The issue arises from multiplying the Cost by a specific percentage (margin). While our calculation works co...
Anonymous First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
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
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
tamerj1
Community Champion
Community ChampionHi Anonymous
What are the columns that exist in the table visual along with the measure? From which table(s)?
Hi tamerj1. This was my final solution and it does work.
Total Cost= var _Table = SUMMARIZE('Campaign_Dimension',[CampaignNameID], Campaign_Dimension[Platform],"Value", [Total Cost Measure])return if(HASONEVALUE(Campaign_Dimension[Platform]), [Total Cost Measure], SUMX(_Table, [Value]))