Adding drillthrough that only filters certain visual

[Rovshan-Hasanov]

Assume this scenario.

I have product overview page that summarizes product information based on category and store (in which store it is present). I have drilltrough page that is intended to give info about one product at a time and gives  info such as price, color, category, AND stores it is present. it also have product name slicer which allows me filter for single product.

Now the problem is when i drill trhrough from an overview page it filters everyting including store info. for example, if I drilled through with filters category = cat A, store = store 1, it will filter the store table to have only values store 1. but one product can be in more than one stores and I want to be able to see all such stores.

Ideal scenario would be to apply drillthrough fillters only to slicer.

How do i do that?

[Kedar_Pande · Accepted solution]

@Rovshan-Hasanov 

Add the necessary fields (e.g., Product Name) to the drill-through pane.

Go to the overview page.
Select the visual that triggers the drill-through.
Click on Format > Edit interactions.
Set the Store slicer to None so it doesn’t get filtered.

Create a measure:

AllStores = CALCULATE(DISTINCTCOUNT(StoreTable[StoreName]), ALL(StoreTable))

Use this measure in a visual on the drill-through page to display all stores for the selected product.

If this helped, a Kudos 👍 or Solution mark would be great!🎉
Cheers,
Kedar Pande
Connect on LinkedIn