Parameter Filter

Hi  thebigrlebowski ,

Here are the steps you can follow：

1. Enter data.

2. Create measure.

Flag1 =
var _select= SELECTEDVALUE('Slicer_Table'[Group])
return
SWITCH(
    TRUE(),
    _select="Radio" && 1 in SELECTCOLUMNS('Left Query Results',"Radio",'Left Query Results'[Radio]),1,
    _select="Sunroof" && 1 in SELECTCOLUMNS('Left Query Results',"Sunroof",'Left Query Results'[Sunroof]),1,
    _select="P Locks" && 1 in SELECTCOLUMNS('Left Query Results',"P Locks",'Left Query Results'[P Locks]),1,
0)

Flag2 =
var _select= SELECTEDVALUE('Slicer_Table'[Group])
return
SWITCH(
    TRUE(),
    _select="Radio" && 1 in SELECTCOLUMNS('Right Query Results',"Radio",'Right Query Results'[Radio]),1,
    _select="Sunroof" && 1 in SELECTCOLUMNS('Right Query Results',"Sunroof",'Right Query Results'[Sunroof]),1,
    _select="P Locks" && 1 in SELECTCOLUMNS('Right Query Results',"P Locks",'Right Query Results'[P Locks]),1,
0)

3. Place [Flag1] and [Flag2] into Left Query Results and Left Query Results respectively.

For example, [Flag1].

Place [Flag1]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

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