Multiple drill through measures

Hi lherbert501 ,

Yes, what you are describing can be achieved, and it's a common pattern when you want to use contextual drillthrough without showing the measure itself on the destination page.

Here's some steps to achieve it:

• You do not need to place the actual measure in the destination tablix for the drillthrough to work. Instead, what matters is the context passed through the drillthrough filter.
• The key is to use categorical fields (dimensions) or filter-friendly fields that are associated with those measures (e.g., Channel, Sale Type, etc.).
• The context (via dimensions like SalesChannel) enables the page-level filters and makes the visual respond correctly.
• This allows you to create a generic destination page that dynamically adapts based on the selected measure’s context.

Here's an example for your reference:

• If you have a SalesChannel field with values like "Phone Call" or "Social Media", and your matrix uses that to split measures, you can drag SalesChannel into the drillthrough filter pane on the destination page.
• When users drill from "Social Media Sales", the page filters to just "Social Media" sales, and the tablix shows all 8 relevant rows.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 Thank you.