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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

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
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

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
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

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.
AlB
Super User
Super User

Hi @Anonymous 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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