Forum Discussion
Getting correct total amount from DAX syntax from sumx() call
Hi GreyMerchant ,
The calculated logic of total value of [Combined Measure Food] measure works like what I explained in this post. Please refer.
You can try the measure as follows. Make sure replace Table with the actual name of your table.
New measure = SUMX(Table,[Combined Measure Food])This may give the same values in the rows, but the correct sum in total.
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it more quickly.
GreyMerchant - 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
Greg_Deckler, thanks for the reply. I saw your posts earlier when I was googling for an answer. I didn't find a quick and easy way to get it to work hence me posting a reproducible problem to get help.
Can I please receive some help on this?
GreyMerchant - Try something like:
Measure 8 = VAR __Table = SUMMARIZE('Table (21)',[Food],[Importance],[Weight],"Measure",[Combined Measure Food]) VAR __Result = SUmX(__Table,[Measure]) RETURN IF(HASONEVALUE('Table (21)'[Food]),[Combined Measure Food],__Result)