Filtering the fact table containing comma separated value and input filter is dynamic

[subhendude]

I have two tables

Dim_Operation

Fact_CallDetails

The Fact_Details table contains the operation field with comma separated list of values. I would like to create two table visuals one for Dim_Operation and another for Fact_CallDetails. Once I click on the operation row of the Dim_Operation table, I want the Fact_CallDetails table to be filtered containing the operation phrase.

Lets take some example

Selecting GET from the Dim_Operation table will return row 1 and row 5.

Selecting PUT from the Dim_Operation table will return row 1 and row 3.

Any suggestion how can I achieve this.

[tamerj1 · Accepted solution]

Hi @subhendude 
Please place this measure in the filter pane of the fact table, select "Is not blank" and apply the filter

Filter Measure =
COUNTROWS (
    FILTER (
        ALLSELECTED ( Dim_Operation[Operation] ),
        CONTAINSSTRING (
            SELECTEDVALUE ( Fact_CallDetails[Operation] ),
            Dim_Operation[Operation]
        )
    )
)