The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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,
User | Count |
---|---|
65 | |
60 | |
55 | |
54 | |
32 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
45 |