Can't display the data because Power BI can't determine the relationship between two or more fields

[Dunner2020]

Hi there,

Although above-mentioned error in the subject line looks common issue with others and I tried to read the existing threads but could not fix my issue by following threads.  Relationship of the data model looks as follows:

Now I am trying to bring in Application ID from Application table, Preferred_Name_formula from Account table and it worked fine. However, when I tried to bring in other columns from other tables then it throws an error message as shown in following picture:

I tried to bring in AuhorisationEffectiveDate column of ECR Authorisation table and it gave me an error. Any help to fix the issue would be really appreciated?

Sample file here

[V-pazhen-msft · Accepted solution]

@Dunner2020 

Try create an inactive relationship between Application table and ECR table using Status ID. Then use userelationship() to call the application id. Something like:

Measure= calculate(max(Application[application id]), Userelationship([ApplicationStatus ID], [AuthorisationStatus ID]))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Dunner2020 , with Application  table, you can bring in data from related dimesnions, which is unsummarized . But not from other facts. I think try are tring to do so