Forum Discussion
Helper IITotals equal 0
I solved this issue by using sumx(values) in DAX.
Great explanations are here:
Obtaining accurate totals in DAX - SQLBI
Helper IIHi Albert,
Anonymous
Thank you very much for your time writing an answer to me.
I have re-created all mesurements, and this is what I am getting, based on one unit example:
Total Supply Column is a sum of two Columns from another Table2, with relationship:
Table 1 (unit number) many to one Table 2 (unit number) . Total Supply is a sum of On Hand qty + On Order Qty. May it affect the measurements?
The $ and Totals values are correct.
Thank you again,
Agata
PS. I am on my holiday from tomorrow, so apologize in advance for the possible delay in aswering.
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
- AgataJ
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