dynamic relation between tables based on slicer

[River]

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,

[arvindsingh802 · Accepted solution]

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

[V-pazhen-msft · Accepted solution]

@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

[arvindsingh802 · Accepted solution]

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