cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CarlsBerg999
Helper IV
Helper IV

Calculate "opposite"

Hi,

 

I have a calculate function in the format of:

 

CALCULATE(SUM(COLUMN1),
FILTER(COLUMN1 = FALSE),

FILTER (COLUMN2 >= 1000),

FILTER(COLUMN3 = VALUE))

 

Can someone help me understand this more deeply:

 

1. What is the order in which the filters are applied? I understand that this is kind of like "sum" if all of the following are true. 

2. How do i do the "opposite" of this? In my data set, if i put the opposite to just the filters, the result is wrong.

 

Thanks for the help!

1 ACCEPTED SOLUTION
dobregon
Post Prodigy
Post Prodigy

@CarlsBerg999  It is not correctly created the query. 

Try to do something like this

 

query= CALCULATE(SUM(yourtable[column1]), FILTER(yourtable, yourtable[column1] = "False" && yourtable[column2] >= 1000 && yourtable[column3] = "Value"))

 

 

This will give to you the sum of column 1 when the row has the 3 condiciones (beucase i put an AND = &&)

if you want, you can put OR = || 




Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

View solution in original post

2 REPLIES 2
dobregon
Post Prodigy
Post Prodigy

@CarlsBerg999  It is not correctly created the query. 

Try to do something like this

 

query= CALCULATE(SUM(yourtable[column1]), FILTER(yourtable, yourtable[column1] = "False" && yourtable[column2] >= 1000 && yourtable[column3] = "Value"))

 

 

This will give to you the sum of column 1 when the row has the 3 condiciones (beucase i put an AND = &&)

if you want, you can put OR = || 




Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

View solution in original post

DataInsights
Super User
Super User

@CarlsBerg999,

 

See the link below for a detailed explanation of CALCULATE. The filter arguments are intersected (merged with the AND operator).

 

https://dax.guide/calculate/ 

 

Would you be able to provide an example of the wrong result (and underlying data) when doing the opposite calculation?

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors