Inactive relationships both cross filter

[lherbert501]

Hi,

I have a simple layout below with a fact stock and fact sales. Because of the items relationship which is both on the cross filter, it wont allow me to create another relationship with the country table which i need to use as the slicer value.

Is there a way around this? Could I use something to make it active?

Thanks

[Ritaf1983 · Accepted solution]

Hi @lherbert501 
You can use, userelationship function inside calculations.

Please refer to the linked article << scenario 2

https://www.vivran.in/post/understanding-ambiguity-in-power-bi-data-model

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

Hi @lherbert501 
You can use, userelationship function inside calculations.

Please refer to the linked article << scenario 2

https://www.vivran.in/post/understanding-ambiguity-in-power-bi-data-model

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[lherbert501]

Hi @Ritaf1983 

Thanks so much for replying.

I think I understand the userelationship in a formula or measure context, but I simply want to use one field out of my country table to use in a slicer.

Does that make sense?

Thanks

[Ritaf1983 · Accepted solution]

You need to create a "country" table which will be a kind of bridge table.
Exactly like on your schema in the question.
Please refer to @amitchandak  tutorial :

https://www.youtube.com/watch?v=Bkf35Roman8

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[lherbert501]

Hi @Ritaf1983 

Sorry - I should of been more clear. The country table is just two distinct rows of two countries wrote out that exist on the stock and sales table and already acts as a sort of bridge. This is still saying indirect 

[Ritaf1983]

Hi @lherbert501 

I'm not sure I'm getting the problem.

Please share a link to dummy pbix to work with...