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
DEMF
BGR
SME

 

And then I have Worker Table like below:

WorkerCompany
JulieBGR
GarryBGR
LisaDEMF
MattSME
SophieSME

 

I cannot put active the Relationship because it already connect with some other table, so im my Worker slicer now, it display all of them instead what already selected in Company slicer

 

Thanks,

 

 

 

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

3 Replies

  • 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