Forum Discussion
Issue with Data Model
Hi together, I have the following data model (reduced view): I need to have the relationship between DimCostCenter and FactAllValues active but it is not possible due to the both filter d...
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
Hi Anonymous ,
thank you for your feedback an explanation.
I will try your provided proposal regarding the DAX functions.
Best regards,
Andreas