cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leo_89
Post Prodigy
Post Prodigy

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

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:

 

 

leo_89_0-1632445258758.png

 

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:

 

leo_89_1-1632445424596.png

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

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@leo_89 

 

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.

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@leo_89 

 

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.

View solution in original post

amitchandak
Super User
Super User

@leo_89 , 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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!