Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

  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 tab...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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