how to off row subtotal for only one value in matrix

[Khushboobarai]

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

[v-veshwara-msft]

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.

Similar behavior discussed here:
Solved: How to hide the total and only one column using th... - Microsoft Fabric Community

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.

[v-veshwara-msft]

Hi @Khushboobarai ,

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

[Khushboobarai]

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

[v-veshwara-msft · Accepted solution]

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.

[v-veshwara-msft]

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

Thank you.

[danextian]

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

[Khushboobarai]

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?

[Natarajan_M]

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

Thanks 

[Khushboobarai]

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. 

[cengizhanarslan]

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
)

[Khushboobarai]

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

[FBergamaschi]

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

[Khushboobarai]

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. 

[FBergamaschi]

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