Forum Discussion

admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

Filter Slicer with inactive relationship

Hi guys,   How to make my slicer correspont with another slicer which has inactive relationship between them.   I have one slicer, lets say Company, which already put as slicer : Company D...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi admin_xlsior ,

     

    We can create a measure and make the table visual filtered by the measure.

     

    Measure = 
IF(MAX(Worker[Company]) in VALUES(Company[Company]),1,0)

     

    Pbix as attached.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi admin_xlsior ,

 

We can create a measure and make the table visual filtered by the measure.

 

Measure = 
IF(MAX(Worker[Company]) in VALUES(Company[Company]),1,0)

 

Pbix as attached.

 

Regards,

Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi admin_xlsior ,

     

    Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

     

    Regards,
    Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Could you please tell me, what does mean by keeing that measure is 1 on the visual filters, how does it related inactive relationship