Forum Discussion
Inactive relationships both cross filter
- 2 years ago
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
- 2 years ago
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
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
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
- Ritaf19832 years ago
Super User
Hi lherbert501
I'm not sure I'm getting the problem.
Please share a link to dummy pbix to work with...