topic Re: how to off row subtotal for only one value in matrix in Desktop

how to off row subtotal for only one value in matrix

Khushboobarai — Tue, 17 Mar 2026 11:53:08 GMT

how to off row subtotal for a single measure? like entirely how can we hide??, when the meaure is switched as row in matrix visual

Re: how to off row subtotal for only one value in matrix

FBergamaschi — Tue, 17 Mar 2026 12:20:59 GMT

Hi @Khushboobarai

can you please specify better what you are asing for and include images?

Thanks

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Re: how to off row subtotal for only one value in matrix

cengizhanarslan — Tue, 17 Mar 2026 12:30:37 GMT

Use DAX so that the measure returns BLANK() at subtotal level.

Measure Display = VAR _Measure = SELECTEDMEASURE() RETURN IF ( SELECTEDMEASURENAME() = "Target Measure" && NOT HASONEVALUE ( 'YourRowField'[RowField] ), BLANK(), _Measure )

Re: how to off row subtotal for only one value in matrix

Khushboobarai — Tue, 17 Mar 2026 12:46:09 GMT

i tried this , but how to hide that row completely?

Re: how to off row subtotal for only one value in matrix

Natarajan_M — Tue, 17 Mar 2026 14:25:02 GMT

Hi @Khushboobarai , Can you explain the requirement using sample data and the visuals you currently have and what you need?

Thanks

Re: how to off row subtotal for only one value in matrix

Khushboobarai — Wed, 18 Mar 2026 08:16:25 GMT

Hi @Natarajan_M , I'm using Matrix visual

Row : item
column: category
value: ,measure 1, m2,m3,m4

where the valeus all switched to row from the value option okay.

when i turn of the row subtotal

it will give me total rows like this

m1total
m2total
m3total
m4total

okay... but i dont want show the m4 total in my visaul, so how to turn off for a one value amonge all? and how can i hide that completely and dynmically.

Re: how to off row subtotal for only one value in matrix

Khushboobarai — Wed, 18 Mar 2026 08:22:32 GMT

Hi @FBergamaschi , I'm using Matrix visual

Row : item
column: category
value: ,measure 1, m2,m3,m4

where the valeus all switched to row from the value option okay.

when i turn of the row subtotal

it will give me total rows like this

m1total
m2total
m3total
m4total

okay... but i dont want show the m4 total in my visaul, so how to turn off for a one value amonge all? and how can i hide that completely and dynmically.

Re: how to off row subtotal for only one value in matrix

FBergamaschi — Wed, 18 Mar 2026 09:33:49 GMT

Hi @Khushboobarai,

please include images so I am sure I get what you want to hide

Thanks

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Re: how to off row subtotal for only one value in matrix

danextian — Wed, 18 Mar 2026 10:28:29 GMT

Hi @Khushboobarai

It depends on at what level of the hierarhcy and/or the value of the hierarchy you want this turned off but this is going to be done using a conditional measure

Re: how to off row subtotal for only one value in matrix

Khushboobarai — Thu, 19 Mar 2026 06:21:04 GMT

Hii @danextian and @FBergamaschi pls check his image,
so from our image @danextian like you shows the blank for the subtotal of revenue so how ti hdi ethat completerly?? like ther eis not point to sho that ro if all are blank, and not even the option to just exclue it....so how to completly hide that?

Re: how to off row subtotal for only one value in matrix

v-veshwara-msft — Mon, 23 Mar 2026 09:47:51 GMT

Hi @Khushboobarai ,

Thanks for reaching out to Microsoft Fabric Community.

In a Matrix visual, when you place measures in Values and switch them to rows, Power BI automatically creates a subtotal row for each measure. There is no built in option to disable the subtotal for just one measure.

You can use DAX to hide the value at the subtotal level by returning BLANK using ISINSCOPE. This is the recommended approach to control totals:
ISINSCOPE function (DAX) - DAX | Microsoft Learn

However, even if the value is blank, the row itself (for example, “m4 total”) will still appear. That row cannot be dynamically hidden for a single measure in the Matrix.

If you need to completely remove that row, the workaround is to use a disconnected table with a SWITCH measure instead of placing measures directly in Values. This gives you control over which rows appear.

Solved: How to exclude or hide a specific row subtotal in... - Microsoft Fabric Community

Solved: Removing blancs from ragged hierarchy in Power BI ... - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.
Thank you.

Re: how to off row subtotal for only one value in matrix

v-veshwara-msft — Fri, 27 Mar 2026 08:44:44 GMT

Hi @Khushboobarai ,

Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.

Re: how to off row subtotal for only one value in matrix

Khushboobarai — Mon, 30 Mar 2026 05:07:02 GMT

Hi, @v-veshwara-msft no not worked relly...it still show the blank column and wont be dynmic the way it should be.. I did off for all not worked !
Thank you

Re: how to off row subtotal for only one value in matrix

v-veshwara-msft — Wed, 01 Apr 2026 04:55:06 GMT

Hi @Khushboobarai ,

Thanks for the update.

The behavior you’re seeing is expected with this setup. Since the measures are placed in Values and shown as rows, those rows are generated by the Matrix visual itself. Because of that, even if the measure returns BLANK using ISINSCOPE or HASONEVALUE, the row (like “m4 total”) will still be displayed. These DAX patterns only hide the value, not the row.

Also, were you able to try the disconnected table approach shared earlier?

Below is a simple example which i tested,

Table:

MeasureTable = DATATABLE( "Measure", STRING, { {"m1"}, {"m2"}, {"m3"}, {"m4"} } )

Measure:

Selected Measure = VAR _measure = SELECTEDVALUE(MeasureTable[Measure]) RETURN SWITCH( _measure, "m1", [m1], "m2", [m2], "m3", [m3], "m4", IF( ISINSCOPE(SampleData[Category]), [m4], BLANK() ) )

Use MeasureTable[Measure] in Rows and Selected Measure in Values and applying a simple “is not blank” filter on the measure removes the row completely and works dynamically.

This way, you can control which rows appear instead of relying on the Matrix-generated measure rows.

Attaching .pbix file for reference.

Hope this helps. Please reach out for further assistance.
Thank you.

Re: how to off row subtotal for only one value in matrix

v-veshwara-msft — Mon, 06 Apr 2026 03:54:10 GMT

Hi @Khushboobarai ,
Just checking if the previous response was helpful. Please let me know if you need any further assistance.

Thank you.