Dax Calculate "IS NOT <>" filtering with multiples values

[Aucesar]

Hi COmmunity,

I Have a calculation like this:

Total =

SUM('BI-Despesas'[nVlrNomiB]) + SUM('BI-Despesas'[nVlrJuroB]) - SUM('BI-Despesas'[nVlrAbatB])

Super simple and working now I need to calculate with the filtes I´m using in the visuals;

How to write this? I tried some and worked with 1 filterd value, but I need to filter all those.

Thanks in advance!

[johnt75 · Accepted solution]

Try

Filtered Total =
CALCULATE (
    SUM ( 'BI-Despesas'[nVlrNomiB] ) + SUM ( 'BI-Despesas'[nVlrJuroB] )
        - SUM ( 'BI-Despesas'[nVlrAbatB] ),
    NOT 'BI-Despesas'[nCodCIPg] IN { 201, 999 },
    NOT 'BI-Despesas'[nCodGrPg] IN { 1001, 1002, 1003 }
)