Urgent calculate with filter error

[Anonymous]

Hello guys!

I'm trying to run these DAX but I'm facing the below issue.

Can you tell me how to solve this?

IF(
MAX(FATO_AR[AGE])="Backlog",
CALCULATE([Montante Real Por Data RNA/CNA],FILTER(FATO_AR,
MONTH(FATO_AR[NOVO_CORTE])=1),
IF(
MAX(FATO_AR[AGE])="Jan/19",
CALCULATE([Montante Real Por Data RNA/CNA],FILTER(FATO_AR,
MONTH(FATO_AR[NOVO_CORTE])=1)))))

[MFelix · Accepted solution]

Hi @Anonymous ,

Try the following measure:

ttt =
CALCULATE (
    SWITCH (
        MAX ( FATO_AR[AGE] ),
        "Backlog", [Montante Real Por Data RNA/CNA],
        "Jan/19", [Montante Real Por Data RNA/CNA]
    ),
    FILTER ( FATO_AR, MONTH ( FATO_AR[NOVO_CORTE] ) = 1 )
)

If it doesn't work can you share a sample file?

Regards,

MFelix

[Anonymous]

It worked perfectly! Thanks a lot!!