cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexITRelation
Frequent Visitor

Summing total columns

2020-02-14_0847.png

Hi all, 
I've a problem regardring PowerBI, which I've tried to illustrate in excel. I've a matrix with Department in rows and Priority in columns and Low, Medium, High and SUM in values. My problem is that I only want to show the yellow column and not the three red columns. Could anybody please help? 
Thanks

3 REPLIES 3
UlfBergqvist
Responsive Resident
Responsive Resident

Perhaps you can return BLANK() if there is a filter on Priority and oterwise return the value?

Measure = IF (ISFILTERED('Table'[Priority]); BLANK(); [MySumMeasure])

Pragati11
Super User
Super User

Hi @AlexITRelation ,

 

Go to FORMAT options of your matrix visual --> Select "SubTotals" --> Navigate down to "Per Column Level" and switch off totals for "Priority" column. By default you will have "Per Column Level" ON for your "Department" and "Priority" columns.

This should resolve the issue.

 

Thanks.

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi @Pragati11 
Thank you for taking your time to reply me. 

 

It seems not to work. Notice that the SUM column is a calculated measure of Low, Medium and High since I want to illustrate the 'grand total' sum the totals (the yellow marked)

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors