How can i create a measure that can pull out value that is a sum of column that is groupby one or more criterias?|Power Pivot|Excel Forum|My Online Training Hub

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