SUBTOTAL PROB

Row subtotals = On

Per row level = On

Hi subratapal2311​,

The replies above are pointing to the correct setting, but based on your description I think the important part is verifying the per-level configuration itself.

Microsoft’s current Matrix format settings documentation states that Per row level lets you control subtotals independently for each level of the row hierarchy.

For your hierarchy:

StudentID
→ StudentName
→ Subject

I would configure it as:

• Row subtotals = On
• Per row level = On

Then use the Row level dropdown and set:

• StudentID → Show subtotal = On
• StudentName → Show subtotal = Off
• Subject → Show subtotal = Off

If you do not want 775 at the bottom, also turn Row grand total off separately.

That should leave only the StudentID subtotal rows.

One thing to watch is that the main Row subtotals toggle must remain On. You only turn the subtotal off for the StudentName and Subject levels from the Row level dropdown.

If you have configured it exactly like that and switching StudentName off still removes the StudentID subtotal in Power BI Desktop 2.159.883.0, then that would not match the currently documented per-row-level behavior.

In that case I would test the same setup in a brand-new matrix with only StudentID, StudentName, Subject and Total Marks. I would also expand all hierarchy levels while testing, because Microsoft notes that expand/collapse can affect subtotal rendering.

If the simplified matrix reproduces the same behavior, please share a screenshot of the Row subtotals pane showing the StudentID and StudentName level settings. That would help determine whether this is a formatting-state issue or a possible regression in the current Desktop build.

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.