how to deduct value from calculate & filter

[Anonymous]

Struggling to figure out how to deduct some of the condition value from the sum

Below is the formula i'm using and error message i receive

"A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

Actual putaway Qty = CALCULATE(SUM('In- MSEG'[In-LTAP.Dest act. qty]),FILTER(all('In- MSEG'),'In -LIKP'[Delivery]='In- MSEG'[Delivery])

-CALCULATE(sum('In- MSEG'[In-LTAP.Dest act. qty]),filter('In-LTAP','In-LTAP'[ Source bin Type]= 922 && 'In-LTAP'[Dest. Type] = "HR1"),

Filter('In-LTAP','In-LTAP'[ Source bin Type]= 922 && 'In-LTAP'[Dest. Type] = "SR1"),

Filter('In-LTAP','In-LTAP'[ Source bin Type]= 922 && 'In-LTAP'[Dest. Type] = "FL1")))

the data set error

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

I think you are missing a parenthesis in the formula before the minus sign. And you might combine the 3 filter() function in the second calculate() function.

Refer:

Actual putaway Qty = 
CALCULATE(SUM('In- MSEG'[In-LTAP.Dest act. qty]),FILTER(all('In- MSEG'),'In -LIKP'[Delivery]='In- MSEG'[Delivery]))
-CALCULATE(sum('In- MSEG'[In-LTAP.Dest act. qty]),filter('In-LTAP','In-LTAP'[ Source bin Type] = 922 && 'In-LTAP'[Dest. Type] in {"HR1","SR1","FL1"}))

Best Regards,

Jay