Forum Discussion
dynamic relation between tables based on slicer
Hi Friends,
Is there a way to dynamicly creating relation between tables based on slicer?
We have a situation that, depending on filter/slicer, the two tables relation will be based on different field, how can I achieve it.
Many thanks,
You can create inactive relationship and based os slicer slection, calculate your measure using any of the relation with USERELATIONSHIP funtion of DAX.
If this post helps, then please consider Accept it as the solution and give it a thumbs up
River
You can only have one static relationship between 2 tables, slicer can only work on report page. There is no way to dynamically change relationship in power bi. Other than the userelationship(), you may also use Treatas() and Intersect() function for virtual relationship.USERELATIONSHIP function (DAX) - DAX | Microsoft Docs
Physical and Virtual Relationships in DAX - SQLBI
Paul Zheng _ Community Support Team
2 Replies
You can create inactive relationship and based os slicer slection, calculate your measure using any of the relation with USERELATIONSHIP funtion of DAX.
If this post helps, then please consider Accept it as the solution and give it a thumbs up
River
You can only have one static relationship between 2 tables, slicer can only work on report page. There is no way to dynamically change relationship in power bi. Other than the userelationship(), you may also use Treatas() and Intersect() function for virtual relationship.USERELATIONSHIP function (DAX) - DAX | Microsoft Docs
Physical and Virtual Relationships in DAX - SQLBI
Paul Zheng _ Community Support Team