Download this exampl PBIX solution from Onedrive
Please click thumbs up for the suggestion,
and click [accept solution] if it works.
Your question is a bit vague, always provide an example desired output to clarify what is required.
Download this exampl PBIX solution from Onedrive
Please click thumbs up for the suggestion,
and click [accept solution] if it works.
Your question is a bit vague, always provide an example desired output to clarify what is required.
Hi speedramps I have see your given example file, and found that the key to get correct result is the selection of "Item No."
Previously, I show "Item No." in my visual from my "Order Lines" table, but after I change the source table for "Item No." from Item table, the total is correct automatically.
Thanks for your help 😊
Olwin thank you.
Yes you understand correctly.
That is why I provide a diagram of the relationships and highlighted in red which fields you needed to select from which tables to use those relationships correctly.
For me the joy cones from not just giving a solution but teaching the method.
Well done on learning it!
