cancel
Showing results for
Did you mean:
Helper IV

## calculate(sum()); and calculate(sum();filter(all) does not ignore filter

Hi,

I am a bitt confused.

calculate(sum()); columnA="B" and calculate(sum();filter(all(columnA);columnA="B"

should ignore the filter contex and show the sum of ALL results where is B in a table.

I tried to produce this in several reports and in some reports its ignores the filter contex and in other reports it only shows the result where the "filter" Expression column A="B".

All the reports have the same structure no other filters etc....

How is this possible????????????++

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

## Re: calculate(sum()); and calculate(sum();filter(all) does not ignore filter

Hi @Coan7

Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.

Best Regards
Maggie
3 REPLIES 3
Super User III

## Re: calculate(sum()); and calculate(sum();filter(all) does not ignore filter

Hi @Coan7

Can you share the pbix or a simplified version that reproduces the problem? Otherwise it's tough to tell

Community Support

## Re: calculate(sum()); and calculate(sum();filter(all) does not ignore filter

Hi @Coan7

As tested,

calculate(sum()); columnA="B" doesn't work on my side, we suggest not creating such dax formula.

For calculate(sum();filter(all(columnA);columnA="B",

i use a example as below

```Measure = CALCULATE(SUM('Table'[NUMBER]),FILTER(ALL('Table'[columnA]),[columnA]="A"))

Column = CALCULATE(SUM('Table'[NUMBER]),FILTER(ALL('Table'[columnA]),[columnA]="A"))```

When you apply [column] in ALL function, it igores the [column], but when there are other columns in visual, the measure would consider other columns.

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support

## Re: calculate(sum()); and calculate(sum();filter(all) does not ignore filter

Hi @Coan7

Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.

Best Regards
Maggie

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors