Issue with Data Model

Hi Anonymous,

The power bi data model is based on AS tableau engine and it only supports one active major relationship. Multiple relationships will cause ambiguity and affect the recognition and aggregation of different table records based on the relationships.

Relationships in analysis services tabular models 

I think you can try to write measure formulas to calculate with TREATAS or USERELATIONSHIP functions.

TREATAS function - DAX | Microsoft Docs

USERELATIONSHIP function (DAX) - DAX | Microsoft Docs

Power BI USERELATIONSHIP vs TREATAS - Enterprise DNA

Regards,

Xiaoxin Sheng