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

Aucesar — Mon, 17 Apr 2023 14:12:17 GMT

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!

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

johnt75 — Mon, 17 Apr 2023 14:24:37 GMT

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 } )

topic Dax Calculate "IS NOT <>" filtering with multiples values in DAX Commands and Tips

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

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