Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi all
I have two tables. In the first table "Contract Management" I have a list of contracts each with a unique ID ("ID" ) and "Original Contract Value". In my second table "Changes Contracts" I have a record of changes "Cost of Changes" occuring for each contract. I used the Related function to extract information from Table 1-"Contract Management" which i have used in other parts of my report.
Table 2:Changes Contracts
Table 1:Contract Management
I would like to create two measures:
1. I would like to have a measure that shows the sum of the original contract values
2. I would then like to have a cumulative measure that takes the Original contract value for each project and adds the changes.
Solved! Go to Solution.
So, I built your two tables exactly as you showed and created a relationship between "Contract Number" columns. I then used Contract Number from the Contract Management table for my slicer. If there is more to the model, let me know, otherwise kind of flying blind.
How about this:
Total = SUM('Contract Management'[Original Contract Value]) Cumulative Total = SUM('Contract Management'[Original Contract Value]) + SUM('Changes Contracts'[Cost of Changes])
Hi,
Unfortunately I can not directly sum from the Contract Management table , due to the relationships in my model, the measure does not update with the filters.
So, I built your two tables exactly as you showed and created a relationship between "Contract Number" columns. I then used Contract Number from the Contract Management table for my slicer. If there is more to the model, let me know, otherwise kind of flying blind.
Hi, That worked as required, I was using my slicers from my Change Contracts Table instead. Thank you for your assisstance,