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 would be able to access all the data in both of these tables. Below is a table of what I am trying to do.
Customer ID and Pen would come from the transaction table and amount would come from the FFAPOC table. Any help or clarification would be greatly appreciated.
| Customer ID | Pen | Amount |
| 123 | 1 | $25.00 |
| 456 | 3 | $45.00 |
| 563 | 2 | $99.00 |
| 111 | 7 | $123.00 |
2 Replies
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.
