Solved: Re: relationships

Anonymous · ‎06-06-2018

Hello every one,

I have an problem in power bi .I have 8 tables and build a relationships .some of the relationships are active some are inactive.When a column drag into the slicer it shows the values only from the tables whice are participate in active relationship.But I want the values from the tables which are in inactive relationship.Please help me.

Thanks,

Chunduri

Anonymous · ‎06-21-2018

Hi Qiuyun Yu ,

I used 'Userelationship function' and it is working.

Thank you.

Regards,

Chunduri

View solution in original post

v-qiuyu-msft · ‎06-07-2018

Hi @Anonymous,

The slicer values are displaying based on active relationships rather than inactive relationships.

In Power BI, we can create a measure to use USERELATIONSHIP Function (DAX) to calculate values based on the inactive relationships. But we can't put a measure in the slicer visual, we can show the final result in another visual eg: table visual.

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.