Power Pivot help needed - managing m2m relationship

John_C_2005 

I'm not sure if GRC table is with unique code or not. If yes, you may use relationships as

combining GRC and RIBB tables.

TREAS you may add using virtual relationships using aggregation like

TR:=CALCULATE( COUNTROWS(TREAS),
    TREATAS( VALUES( RIBB[GRC Product Code] ),
             TREAS[GRC Product Code] )
)

or

TRF:=CALCULATE( SUM(TREAS[Treasury UID]),
     TREATAS( VALUES( RIBB[GRC Product Code] ),
              TREAS[GRC Product Code] )
)

, whatever. In any case you need something in Values of PivotTable, otherwise it always will be Full Outer relationship. Don't know what Treas Filter shall mean, in above is TRF instead.

Finally PivotTable is

If that's what you expect you may remove Unique table at all.

Please check in attached file.