Hide Row Subtotals on Collapse rows

[HankScorpio2]

Hi

I have turned off row subtotals. However, If I collapse the field the row subtotals show again. 

Is there a way to stop any result returning for a row subtotal?

So in the screenshot I would like to permanently hide the cells highlighted in red. 

[shafiz_p]

Hi @HankScorpio2 , To stop any result returning for a row subtotal, just turning of row subtotal should work:

Turn of the row subtotal:

Here is the output, without row subtotal (Tabular style in matrix Layout):

Compact Layout:

If you want to hide specific row subtotal, then go to spcefic column and set only subtotal text color to match back ground:

Finaly, you can programatically turn off any sub total and total. For example:

OrderQty = 
IF(
    HASONEVALUE('Calendar'[Date].[Month]),
    SUM(Sales[OrderQuantity])
)

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,

Shahariar Hafiz

[vicky_ · Accepted solution]

You can modify your measure to use ISINSCOPE, or ISFILTERED or HASONEVALUE:

Quality Mark = IF(ISINSCOPE(YourTable[Date]), // your measure here, BLANK())

 The particular function might depend on your report specifics - you can read more here: https://www.sqlbi.com/articles/distinguishing-hasonevalue-from-isinscope/