March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Dear Community,
Please help to solve an issue with Column SUM for ALLEXCEPT related measure.
Report return expected row results, but sum for this row definitely wrong.
PBI file https://send.firefox.com/download/eb46fe9596ae65ef/#UdUFN3Z6BdOjr3PJIym-Ew
or https://www.plustransfer.com/download.php?id=63432b87a5dd29dd59358ee445c93619&email=%C2%89%7Ftw%7C%C...
Solved! Go to Solution.
Hi @slyfox
I would suggest you create a measure to get the correct total.
Measure = SUMX ( SUMMARIZE ( F_Shipment_Delivery, F_Shipment[SMP_Id], F_Shipment_Delivery[LINK_Delivery_Order] ), [Distr_NegoCost] )
Regards,
Hi @slyfox
I would suggest you create a measure to get the correct total.
Measure = SUMX ( SUMMARIZE ( F_Shipment_Delivery, F_Shipment[SMP_Id], F_Shipment_Delivery[LINK_Delivery_Order] ), [Distr_NegoCost] )
Regards,
@slyfox hi ok so something is wrong, but what are you expecting, can you give me something to compare it to?
Proud to be a Super User!
Hi @vanessafvg
Result for this column should be the same as for SM_Negotiated Cost
@slyfox ok then the problem is your relationships. you have all your relationships set up to bi directional, you should change that to single and that should resolve your issue
Proud to be a Super User!
I was having the same problem and your suggestion solved it! THANK YOUUUU! @vanessafvg
I did not find the answer in your posts. Links are set in the form in which it was required.
If you do not know how to solve the problem with the defined conditions, please ignore the post.
@vanessafvg Suggest workflow cannot be applied because it brings to wrong results in row by row calculations.
https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
Proud to be a Super User!
@vanessafvg
In my example, only 1/20 of the tables used in the model. My question is simple, within the existing data model it is possible to solve the problem or not?
yes as i have said, disabling some of the the bidirectional relationships does this, however this is not as simple as you making out, the onus is on you to understand how power bi works if this does not meet all your requirements. what i am saying is right now based on your relationship model, this is is what is going to be returned, its important to undertand the behaviour of bi directional relationshipsships.
Proud to be a Super User!
@slyfox you mean relationships flow? then you might need to think about remodeling your data because that is what the relationships set up in both directions do.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |