Slicer filtering a table based on more than 1 column

Hi Shubham04 ,

According to your description, you want to use 'Table1'[Campaign] as the slicer and use the corresponding [Solution] field to filter the corresponding KPI table. Is that right?

You can refer to the following steps:

(1) My test data is the same as yours.

(2) We can create a measure:

Measure = var _slicer =VALUES('Table1'[Solution])

var _solution = MAX('Table3'[Solution])

return

IF( _solution in _slicer ,1,0)

(3) Then we help the measure to the corresponding visual "Filter on this visual", and then we can meet your needs.

Best Regards,

Neeko Tang

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