Forum Discussion
Solved
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 be...
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
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.