Forum Discussion
Power BI Summing Issue. Many to one Relationship
Hi jayPBI23,
Would you please use the following measure?
sum = SUMX('Alumni Affiliations Table', RELATED('Metrics Table'[Total Money Raised]))
When you use sum to calculate total, this formula lacks a list filter. When you use sumx, it is equivalent to an iterator. It traverses the Alumni Affiliations Table and sums all the values.
And you can refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ETMy0KXSYp9Cldw6cCowRIIBxE4pMGATEgoLWLYlTInyow?e=h8JTcf
Best Regards,
Dedmon Dai
Hi,
Yes one student ID can be affiliated with more than one school. This is why there is a many to one relationship.
Helper IThen to accomplish that you can create a related calculated column or measure.
And then you can get your desired solution.
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark my post as a solution.
Thanks!