Something like this.
Commit by Vessel:=VAR CommitVsl =
GROUPBY (Committed, Committed[Vessel], Committed[Cost Elem.],
"CommitSum", SUMX( CURRENTGROUP(), Committed[Commit]))
RETURN
SUMX(CommitVsl, [CommitSum])
The budget table have only one cost center for the vessel.
The commit table has two cost centers for the same vessel.
But i need to be able to show the correct values when i reference it in a pivot-table.
Vessel | Budget | Commit
Hi Francis,
Please provide a sample file. My imagination isn't that good 🙂
Mynda
Hi,
Please find attached sample. I have not created the measure since it is giving me wrong result.
If you refer to the sample, commit amount is not correct for the "B-type".
I need to fix both the commit amount.
Hi Francis,
You don't have BBB-1 in your Type table, this is why there is a '(Blank)' Name in the PivotTable in columns O:Q.
Mynda
