Filter data based on values selected from slicer

[dp106]

Hi,

I have a question regarding DAX function and its usage.

Here is the scenario.

I have data from 2 tables having with many to many relationship so could not set the relationship in the data model.

The first table contains the customer info and other details. The second tables contains Business units. Each customer could be in multiple business unit. I need an slicer on the business unit column and based on the selection, the customers corresponding to that business unit should be displayed/ filtered. 

I tried using DAX function filter but could not get thru. any help will be appreciated.

This is easy if the relationship is set  but unfortunately i cant do so as there are other complexities involved.

Thanks.

[v-chuncz-msft · Accepted solution]

@dp106,

Here is an example for your reference.

[dp106]

Excellent. !!!!

Thanks