Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HenryJS
Post Prodigy
Post Prodigy

Matrix Totals

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.

 

 

Capture.PNG

1 ACCEPTED SOLUTION
v-yetao1-msft
Community Support
Community Support

Hi @HenryJS 

I created a sample ,maybe you can refer to it

Original data and the effect of adding a measure

Ailsa-msft_0-1620981455710.png

Ailsa-msft_1-1620981455712.png

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 .

Ailsa-msft_2-1620981455714.png

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.

View solution in original post

2 REPLIES 2
v-yetao1-msft
Community Support
Community Support

Hi @HenryJS 

I created a sample ,maybe you can refer to it

Original data and the effect of adding a measure

Ailsa-msft_0-1620981455710.png

Ailsa-msft_1-1620981455712.png

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 .

Ailsa-msft_2-1620981455714.png

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
Super User
Super User

@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/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.