Filter Slicer with inactive relationship

[admin_xlsior]

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:

Worker	Company
Julie	BGR
Garry	BGR
Lisa	DEMF
Matt	SME
Sophie	SME

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,

[v-frfei-msft · Accepted solution]

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

[Anonymous]

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

[v-frfei-msft]

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