Forum Discussion
Access Data Based on Relationship Question
I have four sheets that I am bringing into PowerBi and have created the below relationships. What I was thinking I would be able to do was that since I have a table between to of the main tables I w...
In this scenario, your Transaction and Pen tables are under "Many to One" relationship. It's also "Many to One" between Pen and FFAPOC tables. So the Customer ID and Amount are under "Many to Many" relationship, you can't directly include them into a table.
For your requirement, you can create a Total Amount Measure to aggregate the Amount column instead of directly including Amount column.
Regards
Make the relationship between Transaction and Pens table as directional. Let me know the outcome.