Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Over-ride slicer filter and keep the measure

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.
Screenshot 2023-06-01 182131.png
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..
Frequent Visitor

hello again,

attached pbix file. here is download file.


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

Screenshot 2023-06-05 113422.png


Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors