cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Coan7 Helper IV
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
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

View solution in original post

3 REPLIES 3
Super User III
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
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

Capture5.JPG

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.

Please read more details below:

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
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

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

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

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘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