Power BI Slicer

Hi  BIswajit_Das ,

Here are the steps you can follow：

1. In Power Query , copy the Table.

Table(2)：

Select [age] and [id] – Home – Remove Columns.

Right-click the mouse -- Remove Duplicates:

Table(3)：

Select [gender] and [id] – Home – Remove Columns.

Right-click the mouse -- Remove Duplicates:

Table(3)：

Select [gender] and [id] – Home – Remove Columns.

Right-click the mouse -- Remove Duplicates:

2. Home – Append Queries -- Append Queries as new .

Select both [gender] and [age] -- Right-click the mouse – Merge Columns.

3. Create measure.

Measure =
var _select=SELECTEDVALUE('Append1'[Merged])
return
IF(
    _select in SELECTCOLUMNS('Table',"age",CONVERT('Table'[age],STRING)) || _select in SELECTCOLUMNS('Table',"gender",'Table'[gender]),1,0)

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

5. 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