Relationships not working between 3 tables

[Jasonwalker]

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

[v-shex-msft · Accepted solution]

Hi @Jasonwalker,

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

[Greg_Deckler]

@Jasonwalker Check out the USERELATIONSHIP function.