Forum Discussion
Hide Row Subtotals on Collapse rows
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/
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