FILTER with "NOT" issue

[setis]

Dear experts,

I am doing someting wrong when using NOT in a filter.

I have a calculated column that is giving me either "Above Average" or "Below Average" in my Sales table

I am trying to filter the "Above Average" Sales amount using the following measure:

#Sales AboveAvrg = 
VAR SalesAmount = SUMX ( Sales; Sales[Quantity] * Sales[Net Price] )
RETURN
CALCULATE(SalesAmount;
FILTER(ALL(Sales);NOT(
    Sales[Delivery State] = "Below Average")))

The problem is that this is giving me the full Sales Amount.

I am able to obtain the correct result using:

#Sales AboveAvrg2 = 
CALCULATE([Sales Amount];
FILTER(Sales;Sales[Delivery State] = "Above Average"))

Why is the first one not working?

Please find the file here: https://drive.google.com/file/d/1MlHXk1r6icFmlPrwV7wulN5k49C95xkt/view?usp=sharing

[Zubair_Muhammad]

@setis 

In the first MEASURE you are using a Variable as expression for CALCULATE function.
Variables are just store of value. They do no respond to EVALUATION CONTEXTs

#Sales AboveAvrg = 
VAR SalesAmount = SUMX ( Sales; Sales[Quantity] * Sales[Net Price] )
RETURN
CALCULATE(SalesAmount[Sales Amount];
FILTER(ALL(Sales);NOT(
    Sales[Delivery State] = "Below Average")))

[setis]

Dear @Zubair_Muhammad ,

Thanks a lot for your answer, 

I tried to obtain the correct result using the measure for Sales Amount instead. I get the correct result, but not respecting the row context. 

Please see the image below. 

How can I obtain the result I get in the third column using the NOT function?

[Zubair_Muhammad · Accepted solution]

@setis 

Sorry for late reply.

This is because you are using ALL(Sales) in the first formula

All removes all the filters from the Table used as argument and associated one side Tables .