Forum Discussion

Helper III

6 years ago

Solved

Use inactive relationship for slicer

Hi Gurus, Let's say I have two tables, one is the Branch Table, another one is the Fact Table. I created two relationships to connect Cities code, Active one connected to the sending Branch, Inacti...

Need Help

Pragati11
6 years ago
Hi clubspec ,

There is an existing thread for this. Chek it:
https://community.powerbi.com/t5/Desktop/Filter-Slicer-with-inactive-relationship/m-p/644640

Also, there is a way to use Inactive relationship as an Active one by using USERRELATIONSIP function. Check the thread here:
https://community.powerbi.com/t5/Desktop/using-inactive-relationship/m-p/1195011
There is also a blog on this:
https://hatfullofdata.blog/power-bi-using-inactive-relationships-in-a-measure/

Thanks,
Pragati

clubspec

Helper III

6 years ago

Hi Pragati11

So must either use the measure method you mentioned or create a measure but filter with USERELATIONSHIP?

I hope there is something more simple (the trouble is I have to recreate lots of measures with USERELATIONSHIP)
If Power BI slicer can have a feature by nominating a relationship that would be awesome.

Thanks for your help anyway.

Pragati11