Unable to create SINGLE CROSS FILTER RELATIONSHIP between DIM and FACT table

[Anonymous]

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!

[v-shex-msft · Accepted 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

[Anonymous]

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