Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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 |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |