Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter function - with two conditions on the same table

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"))
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi,

    It was a user mistake the formula is working now.

    Thanks a lot for your feedback.

    PaulDBrown 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

    It was a user mistake the formula is working now.

    Thanks a lot for your feedback.

    PaulDBrown