Calculate "opposite"

[CarlsBerg999]

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!

[dobregon · Accepted solution]

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

[DataInsights]

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