Forum Discussion
Solved
SUBTOTAL PROB
Title: Power BI Matrix — How to Show Subtotal Only at StudentID Level, Not StudentName Level? I am using Power BI Desktop October 2026, version 2.159.883.0 (64-bit). My Matrix visual has: Rows: S...
I have tried with sample data of 10 records. Can you update these formatting option show in image
DavidAnthony
Helper II
Helper IIHi subratapal2311, if the per-level toggle keeps removing the StudentID subtotal, you can sidestep it by collapsing the two levels into one, since StudentName is one-to-one with StudentID:
add a column
Student = Students[StudentID] & " - " & Students[StudentName],
set Sort by column to StudentID, and use Rows = Student → Subject.
You then get one subtotal row per student, no StudentName subtotal, and the grand total stays (turn Row grand total off if you don’t want it).