Filter a table with a slicer but on a different column

[PJOS_1]

Ok, I've looked and looked and can't quite find what I need on this. I have a slicer (not visible) that will be connected to this table visual. The selections in the slicer are from my [Property Name] column shown below. What I'd like this table to do is upon the user selecting, say, "Greenfield", the below table visual filters against "Operator" 

No filter applied:


User selected "Greenfield" from slicer.
Desired output:

Any idea how to do this? Thanks in advance.

[v-eqin-msft · Accepted solution]

Hi @PJOS_1 ,

According to my understanding, you want to filter out all rows of the same Operator with the selected Property Name in slicer,right?

You could firstly create a separate table for slicer:

ForSlicer = VALUES('Table'[Property Name])

Then use the following formula to create measure:

Measure =
VAR _op =
    SUMMARIZE (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Property Name] IN ALLSELECTED ( ForSlicer[Property Name] )
        ),
        'Table'[Operator]
    )
RETURN
    IF ( MAX ( 'Table'[Operator] ) IN _op, 1, 0 )

And apply it to filter pane, set as "is 1" like this:

Please take a look at the pbix file here.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PJOS_1]

Fantastic! That did it!

[negi007]

@PJOS_1 Please tell me how greenfield selection is related to other filterd fields. I can't see  I would suggest you to create a new table where you will have below fields

Main_Property_Name

Property name

Property name above can be used to link new table and main table which is shown above by you. This way your filter from new table will work on your existing table. 

Let me know if i am missing something here

[PJOS_1]

Both Operator and Property Name are on the same lookup table which has 25 records. There are no other filters on this table visual.

Let me make sure I understand: If I add another table with my list of unique operators and connect it to this table with my properties, I should be able to pull this off? 

Thanks for the help, I'm new to PBI.  

[PJOS_1]

I did what was suggested and I still can't get it. I'm thinking this isn't possible.