Filter function - with two conditions on the same table

[JulioCastillo]

Hello

I'm trying without success to create a filter. The first filter is working fine if he stands alone.

As soon as I try to add the second condition I get an error message.

Thanks in advance for your input.

Delivery Costs =

Calculate(SUM('Anticimex AG$G_L Entry (2)'[Amount]),FILTER(Pnl,Pnl[Category II] = "COSTS"),

FILTER('Anticimex AG$G_L Entry (2)',[Global Dimension Code 1] = "DE"))

[JulioCastillo · Accepted solution]

Hi,

It was a user mistake the formula is working now.

Thanks a lot for your feedback.

@PaulDBrown 

[PaulDBrown]

What error are you getting?