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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Anonymous
Not applicable

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 logo


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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors