Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |