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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Dan_at_TWE
Helper III
Helper III

I want to sum a column but ignore certain rows

I want to sum a column but ignore certain rows.   I know to sum only certain rows you do something like this:

 

MEASURE = CALCULATE(SUM('Table'[Values]), 'Table'[Location] = "London")

 

Let's say I want to sum the column values but EXCLUDE "London". Would this be right?  (Using a "!=" instead of "=".)

 

MEASURE = CALCULATE(SUM('Table'[Values]), 'Table'[Location] != "London")

 

 

1 ACCEPTED SOLUTION
samratpbi
Super User
Super User

Hi,

 

can you please try below:

MEASURE = CALCULATE(SUM('Table'[Values]), 'Table'[Location] <> "London")

If this helps to solve your problem, then please mark it as solution, thanks

View solution in original post

3 REPLIES 3
samratpbi
Super User
Super User

Hi,

 

can you please try below:

MEASURE = CALCULATE(SUM('Table'[Values]), 'Table'[Location] <> "London")

If this helps to solve your problem, then please mark it as solution, thanks

The solution does work as expected.  But it doesn't "float down" to the visual.  I suspect I need to look at another nesting with some of the filter functions (ALLFILTER or whatever...).   But your answer did get me to where I "thought" I needed to go. Thanks. That much closer...

Thanks. I'll give that a try.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.