cancel
Showing results for
Did you mean:
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.

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Super User IV

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

#### Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors