Create Relationship to Add Field to Matrix Report

Hi whenriques ,

Please check if this is what you want.

Total Overrun =
CALCULATE (
    SUM ( 'Overrun Data'[amount] ),
    USERELATIONSHIP ( TopRankingQuery[OrgName], 'Overrun Data'[Organization] ),
    FILTER ( 'Overrun Data', 'Overrun Data'[OFRmapping] IN { "overrun" } )
)

The basic logic is to create an inactive relationship and use USERELATIONSHIP() function to active the relationship while doing the calculation.

Best Regards,

Jay