Enabling Drill Through button for Horizontal Total in Matrix

Hi PremK ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you amitchandak for the prompt response.

Why Drill-through Doesn't Work on Horizontal Totals (Bottom Total Row):
The bottom total row in Power BI Matrix visuals represents an aggregate (Grand Total). This row doesn't contain the actual category context, which is what the drill-through functionality needs to work properly.

 You Can Try Below:
To make drill-through from that total row work (or simulate it), here's a more detailed explanation:
1. Add Measures to the Drill-through Page Filters:
In your drill-through page, make sure you're not just adding categories (like "Brand" or "Marketer"), but also add the Measure (like "Revenue" or "Net").

• Go to the drill-through page.
• In the "Drill-through" pane, under “Drill through from”, add both:
• The category (e.g., Marketer)

• The measure (e.g., Revenue)

• This makes the page aware of what value you're trying to pass, even from total rows.

2. Use a Separate Visual as a Workaround:

If you're trying to drill through from the total (bottom horizontal row), consider creating a card visual or custom button that passes predefined filters when clicked. This simulates drill-through for the grand total.

3. Use DAX to Identify Totals:

Create a DAX measure that checks if the current row is a total using ISINSCOPE() or HASONEVALUE():
IsTotal = IF(ISINSCOPE('Table'[Marketer]), "Detail", "Total")
Then use this to enable actions or conditional formatting, or as part of your drill-through logic.

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.