problem with reporting on multiple relationship

[iLikeAzureSQL]

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

[v-shex-msft · Accepted solution]

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

[iLikeAzureSQL]

Can you do this on dorect query reports?

[v-shex-msft]

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

[BhaveshPatel]

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.