Partial filtering by slicer

[SamuelMei]

Hi everyone,

This might be a stupid question but

I have a dashboard showing product information. The product is selected by by selecting a ProductID with a slicer. 

By selecting the ProductID in the slicer, I automatically select the Product Group, Device Family, etc. 

The problem is that now I am trying to add a table that shows similar products to the selected product, i.e. show ProductIDs of products that belong in the same Product Group and Device Family.

One way to do it is to first unlink the interaction between the original slicer and the new table. Then, have multiple slicers for just the Product Group and Device Family to filter the table. This achieves the purpose, but requires the user to check many more boxes than they should be required to do. Hence this method is not ideal. 

Any help is much appreciated. 

[V-lianl-msft · Accepted solution]

Hi @SamuelMei ,

Based on your description, you want to filter the productid with slicer. Then display the productid of the same Product Group, Device Family with another chart.
First, you can copy the table, then create a measure and add measure = 1 as a condition to visual filter.

Please refer to the pbix.

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

[SamuelMei]

@V-lianl-msft  Thanks for your answer. Sadly my organization is still running Power BI Janurary 2019 so I could not open your pbix. I have duplicated the table, but can't seem to figure out the DAX for the measure. Could you please upload the DAX? Thanks very much.

Edit: i have figured it out. Thank you @V-lianl-msft 

[V-lianl-msft]

Hi @SamuelMei

 

You can refer to the DAX:

Measure = IF(MAX('Table'[product_group])=SELECTEDVALUE(Sheet1[product_group])&&
            MAX('Table'[Device Family])=SELECTEDVALUE(Sheet1[Device Family]),1,0)

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