How to apply filters bidirectionally only for one filter search?

[sasdfasdfsad]

With this example data model:

I want to do a search for CustomersLogin table's "LoginEmail" and that works totally fine.

HOWEVER, if we need to search by an ALTERNATIVE email in the CustEmails table, that's where I am running into issues due to directional filtering.

Now if I do CustomerID 88 with LoginEmail fo bob@msft.com it works just great

Imagine though bob forgot his login email and we want to search all his possible AltEmails so we do bob@msdn.com
Now of course it falls apart as filtering is not bidirectional

However, if I enable bidirectional filtering that impacts my entire data model.

Can I use bidirectional filtering for only a SPECIFIC filter or measure or instance?

OR... 

Can I do some sort of lookup where I find the CustomerID in the CustEmails tables and then apply that filter across the PBI page?

*I could add the CustEmail.AltEmails column to that specific filter as a hierarchy but I'd like to find a way to make it work more naturally than that.

Is there anyway to do that?

[amitchandak · Accepted solution]

@sasdfasdfsad , If you want to just make the slicer filter each other 

from RADACAD

https://www.youtube.com/watch?v=cyOquvfhzNM

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

Same way you can create a measure using treatas to pass the values across

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

[Anonymous · Accepted solution]

Hi @amitchandak ,thanks for the quick reply, I'll add more.

Hi @sasdfasdfsad ,

Regarding your problem, maybe you can use the 'CROSSFILTER' function.

CROSSFILTER function - DAX | Microsoft Learn

Use the following DAX expression to create a measure

Measure = CALCULATE(MAX('CustomersLogin'[LoginEmail]),CROSSFILTER('CustEmails'[CustomerID],'CustomersLogin'[CustomerID],Both))

Final output

Best Regards,
Wenbin Zhou

[amitchandak · Accepted solution]

@sasdfasdfsad , If you want to just make the slicer filter each other 

from RADACAD

https://www.youtube.com/watch?v=cyOquvfhzNM

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

Same way you can create a measure using treatas to pass the values across

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/