Request help with table relationships

[Vanya]

Dear All,

I am a beginner in Power BI, I am having trouble in building table relationships for one of my reports. I guess I have built a loop which is preventing me from getting the desired output. When I try to create report, I am recieving the relationship error message.

Please click here for sample pbix file. The expected output report should have the following columns.

Name	City	Sedate	Fname	Lname	Present	Type	Fname

Any help or support in this regard is greatly appreciated.

Thank you,

Regards,

Vaniya

[Anonymous · Accepted solution]

HI @Vanya,

AFAIK single relationship only works on one side.(one side filter many side)

For your scenario, it obviously need to enable 'both' option for 'cross filter direction'.(current power bi can't accurate mapping records through multiple tables with single relationships)

Based on test, your report contains conflict available relationships which power bi not support.

So you can't modify relationship filter mode at tables who contains conflict multiple available relationship.(P_EA, SE_EA, P_GBM, GB_GBM)

In my opinion, you need to deactivate one of above relationships and modify other tables to 'cross filter direction' 'both', then write measures with userelationship function to active relationship to calculated result to replace not available relationships.

Reference:

Using USERELATIONSHIP function in Measures and Calculated Columns #dax #powerpivot #ssas

Regards,

Xiaoxin Sheng