Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

relationships

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...
Data Modeling
Reports
  • Anonymous's avatar
    Anonymous
    8 years ago

     Hi Qiuyun Yu ,

     

    I used 'Userelationship function' and  it is working.

    Thank you.

     

    Regards,

    Chunduri

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     Hi Qiuyun Yu ,

     

    I used 'Userelationship function' and  it is working.

    Thank you.

     

    Regards,

    Chunduri