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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sistancy
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.

2 REPLIES 2
Mahesh0016
Super User
Super User

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

@sistancy THANK YOU!!

barritown
Super User
Super User

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. 

barritown_0-1685625255305.png

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors