Forum Discussion
Totals equal 0
I solved this issue by using sumx(values) in DAX.
Great explanations are here:
Obtaining accurate totals in DAX - SQLBI
Hi AgataJ ,
Thank you for your reply, the above method is applicable to the example data you provided earlier. Regarding the new question, please provide detailed example data including the two tables you mentioned and the relationship between them so that we can help you faster. Please hide sensitive information in advance.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Albert, Anonymous
Late answer but I was trying to work this out, unfortunately no success. Attached is the PBI file with where I am now. I managed to get correct Total for all measurement that counts Quantity. Unfortunately, that can't be said about Sum ($) for Excess.
The current results I am getting for Excess $ and Excess to 0 Demand $ are: 235.71 and 110, whereas I expect 160 and 120.
I would appreciate your feedback.
Kind regards,
Agata