Forum Discussion
Displaying Data across multiple tables
Hello everyone,
I am trying to create a visualization that will list out management fees for each tenant.
This is part of my data model:
I am able to create a table visualization and add data from the tenant's table, renttranscation table, lease table, property table Like this:
However, when I try to add anything from the agreement table, I get this error:
I know the problem is the relationship between Lease ->Property->Agreement, but I can't figure out why. Here are the settings:
It's a many to one relationship between lease and property, then a 1 to many between property to lease.
There is a look up column in the lease table for property and likewise a lookup column in the agreement table to link to a property.
I was thinking if the lookup column from both table matches, the relationship should flow through.
What am I missing here?
Thanks in advance.
3 Replies
Hello areseia, and thank you for sharing a question with the Community. Please remember to adhere to the decorum of the Community Forum when asking a question.
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.Hi,
One will have to look at the file to identify the problem. Share the download link and keep only the tables that are required. Remove the unrequired ones.
Assuming this database follows standard protocols there will be ID columns that you've done your joins on.
Create a custom column in the Property table that is essentially a vlookup to the Agreement table. This will let you bring relevant information into the Property table based on the ID link. You can display custom columns in place of any columns you need from the Agreement table.
the formula you want is LOOKUPVALUE:
https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
