Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, as shown above, I have a problem creating a single crossfilter direction between the "Region and Store" and The "WF Take With" table. This is due to the fact that the WF Take With table has only one record, and therefore PBI is creating a 1:1 relationship. Region table is the DIM table while the WF Take With is the fact table. I know there will be more records coming into the fact table, but power bi doesn't take that into consideration and creates a 1:1 relationship.
Due to the BOTH cross filter direction in this relationship, Power BI creates ambiguity between the WF Take With and the Salesperson table. When I try to make the relationship between those to tables active, I get an error that I need to delete on of the relationships between the Salesperson table and other tables.
Is there a workaround for this? How do I "make" Power BI to create a single cross filter direction relationship between the table with one record and the dim table?
Please help!
Solved! Go to Solution.
Hi @Anonymous ,
AFAIK, current power bi only allow your to active one major relationship to link tables. If they exists multiple available relationship fields, power bi will make other relationship inactivated to prevent ambiguity.
Normally you can change activated relationship fields to use relationship which you mentioned to link other fields and analytics.
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
AFAIK, current power bi only allow your to active one major relationship to link tables. If they exists multiple available relationship fields, power bi will make other relationship inactivated to prevent ambiguity.
Normally you can change activated relationship fields to use relationship which you mentioned to link other fields and analytics.
Regards,
Xiaoxin Sheng
HI, thanks for your response. I have fixed the model. For some reason, it looks like there was a duplicate relationship between the two tables. Once I removed it, it allowed me to change the cross filter to "single" and make the other relationship active.
Thanks again,
Izolda
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |