Forum Discussion
Solved
Getting correct total amount from DAX syntax from sumx() call
Hello, I have a little toy problem I put together for my actual problem. The data you can use is the below: Food Importance Weight 120 100 2000 80 95 3000 50 86 4000 ...
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.
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?