Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |