Enabling Drill Through button for Horizontal Total in Matrix

[PremK]

Ive created a Matrix table with Revenue of Sales Reps over Months and Weeks. and added a Drill Through button.
whenever  click any value or vertical total the drill through button is getting enabled, But if i click Horizontal Total the drill through button is not enabling.

how to enable this Horizontal Totals for Drill through ??

[PremK · Accepted solution]

I directly created a table by selecting Columns from original table with additionally creating rows like all marketers, all categories. then added this in the matrix and disabled row total. this all rows, all marketers,,, will act as totals

[v-venuppu]

Hi @PremK ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[amitchandak]

@PremK , Horizontal total to me seems like Grand total, so I doubt you will get. But check if you add the measure to the drill-through page's drill-through (where you added the category )

Drill through on total

[PremK]

Hi  amitchandak,
I couldn't understand your point. can you pls clarify me with bit more details 
I want to drill through from the bottum total 

[v-venuppu]

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.