Forum Discussion
Relationships not working between 3 tables
Hello Users,
Currently attmepting to run a report from 3 tables. What I want to do is:
Select a date on a line graph. Then to the side there will different data fields from each of the tables (example shown) However, when selecting the month, only data from one of the table uploads. I 100% think I can do this and it's an issue with my relationships.
Can anyone assist please?
Showing the month selected and which data is correct and wrongRelationships in the report. Solid Lines = Machine. Dotted = Monthshowing which data comes from which table
Hi Anonymous,
Power bi uses analysis service tabular model to store records, it does not support multiple active relationships between tables.
Relationships in analysis services tabular models
You can consider using treatas or userelationship functions to write DAX format to calculate with DAX formulas.
Power BI USERELATIONSHIP vs TREATAS - Enterprise DNA
Regards,
Xiaoxin Sheng
2 Replies
- Greg_Deckler
Community Champion
Anonymous Check out the USERELATIONSHIP function.
Hi Anonymous,
Power bi uses analysis service tabular model to store records, it does not support multiple active relationships between tables.
Relationships in analysis services tabular models
You can consider using treatas or userelationship functions to write DAX format to calculate with DAX formulas.
Power BI USERELATIONSHIP vs TREATAS - Enterprise DNA
Regards,
Xiaoxin Sheng
