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