Filtering the fact table containing comma separated value and input filter is dynamic
I have two tables
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.