Matrix Totals

[HenryJS]

Hi all,

Is it possible to turn off totals for particular rows in a matrix? I want those highlighted below OFF and the rest of the totals to still show.

[v-yetao1-msft · Accepted solution]

Hi @HenryJS 

I created a sample ,maybe you can refer to it

Original data and the effect of adding a measure

You can see that the subtotal for Country=”UK” is removed .But the grand total is still kept .

Create a measure like :

Measure =

IF (

    ISINSCOPE ( 'Table'[Country] ),

    IF (

        MAX ( 'Table'[Country] ) = "UK",

        IF ( ISINSCOPE ( 'Table'[Store] ), SUM ( 'Table'[Price] ), BLANK () ),

        SUM ( 'Table'[Price] )

    ),

    SUM ( 'Table'[Price] )

)

Then use the measure replace the value in Visual Values .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@HenryJS , You can make them blank based on condition

using isfiltered or isinscope https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/