Forum Discussion
dynamic relation between tables based on slicer
- 5 years ago
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
- Anonymous5 years ago
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
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