Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

don't calculate overall sum for a special column

Hello everyone,
I have a basic visualized matrix with a basic SUM([Column]) as a column in the table. The table has a inner filter and I just use "SUM" for my calculation because it needs an aggregation to be able to show the result. So the inner Filter then splits every value in the right way. The problem is tho that it shows an overall sum for this column in this table which makes no sense for this case. But I still have another column in this table where I need the overall sum, thats why I cant disable the overall sum in the format settings.

Is there a way to edit my measure SUM([Column]) so it doesn't show the overall SUM of this specific column? I'd like just a blank spot instead.

Solution Sage
Solution Sage

Measure =
     ISINSCOPE(Table[Column]),[Sum of Sale],0)

@sistancy THANK YOU!!

Solution Sage
Solution Sage

Hi @sistancy,

The solution depends on your precise case, I guess.

If, for example, the filiter in your case is applied to the column which is not used in the row section of your matrix, you can apply a solution like the one on the screenshot below. 


Best Regards,


My YouTube vlog in English

My YouTube vlog in Russian


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors