Forum Discussion
Post ProdigyInactive relationships both cross filter
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
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
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
5 Replies
- Ritaf1983
Super User
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
lherbert501Hi 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
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