Forum Discussion
One-to-Many Relationship; Matrix Layout
Hello, I have a report I am trying to consolidate. This report involves gathering data on a transactional basis, summing it, and comparing it to a budget. For example, I have 3 employees who ...
Hi Anonymous ,
You need to create a relationship between both tables, and then create the following measure:
Budget Remaining = SUM(Budget[Budget])-SUM(Purchases[Transaction Amount])
Now create your matrix accordingly to the following:
- Rows: Name (Budget Table)
- Values:
- Budget (Budget Table)
- Transaction Amount (Transaction Table)
- Budget remaining (Measure created previously)
Check the result in the PBIX file attach (August version).
Regards,
MFelix
To anyone else who finds this post, MFelix helped me out over at this post.