Forum Discussion
problem with reporting on multiple relationship
Hello everyone,
I can't make multiple relantionship to work. Here is what I have:
Address Table - AddressID PK
Person Table - PersonID PK
PersonAddress Table - PersonAddressID PK - relation bewtween Address and Person
Class table - ClassID PK
PersonClass Tabale - personclassID PK - relation netween person and class
When I male a report with Address and Peson table fields it's all good, same as when reporting on person and class
but I can't add any fileds from the far table when I want top report from Address, Person and Class tables. It's complainig about missing relation but the relation is there and individual reports are working
Any idea what's going on and how to fix this ? it looks like a powerbi limitation or soemthing that I'm missing here
Hi iLikeAzureSQL,
I create a simple sample to test but it works on my side. Below is the sample:
Table:
Relationship:
Visual:
Use relationship create a summary table.
Formula:
Table = SELECTCOLUMNS(PersonClass,"PersonclassID",[personclassID],"Person",RELATED(Person[Name]),"Class",RELATED(Class[ClaseName]),"Address",RELATED(Adress[Decription]))
Regards,
Xiaoxin Sheng
4 Replies
You should understand the logic of how relationships flow and how the cross filtering works in PowerBI. Please refer to this BLOG on understanding relationship dynamics.
Hi iLikeAzureSQL,
I create a simple sample to test but it works on my side. Below is the sample:
Table:
Relationship:
Visual:
Use relationship create a summary table.
Formula:
Table = SELECTCOLUMNS(PersonClass,"PersonclassID",[personclassID],"Person",RELATED(Person[Name]),"Class",RELATED(Class[ClaseName]),"Address",RELATED(Adress[Decription]))
Regards,
Xiaoxin Sheng
Can you do this on dorect query reports?
Hi iLikeAzureSQL,
I think it can't works on direct query mode. Perhaps you can try to do these work on database side.
Regards,
Xiaoxin Sheng
