Over-ride slicer filter and keep the measure

[BeqaBeglara]

Hello evryone,

doing retail business analysis and got one unsolved issue. i have products and cheques, where i counted distinct value of cheques by 

Dcount = DISTINCTCOUNT('Unique Checks With prods'[Check]).  When i filter, For example, Category beer, in report displays prod_id's with disticnt count of cheques. by clickin on one product display cheques with amount of sales in a second report.

the problem is that i need to catch intersection of one product to anothers. for example, if click one product i want the second report unite the cheques and display what type of products and how many are intersected with clicked product.

Thanks in advance..

[BeqaBeglara]

hello again,

attached pbix file. here is download file. https://we.tl/t-32hedgnX5I

also, here is the outcome, i'd like to get. filtered by Jan-Feb.

 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...