Measure to sum column with multiple filters

[webportal]

I want to sum the absolute value of column "Saldo" in table "Balancete Geral", whose column "Conta" is:

• 11
• 12
• 13

In a single measure.

This can be achieved with Calculate, like:

Measure = 
CALCULATE (
    ABS ( SUM ( 'BalanceteGeral'[Saldo] ) );
    BalanceteGeral[Conta] = 11
)+
CALCULATE (
    ABS ( SUM ( 'BalanceteGeral'[Saldo] ) );
    BalanceteGeral[Conta] = 12
)+
CALCULATE (
    ABS ( SUM ( 'BalanceteGeral'[Saldo] ) );
    BalanceteGeral[Conta] = 13
)

But, isn't there a more efficient way to use the CALCULATE filter to consider 3 or more filters?

I could use OR in a single filter, but it only accepts two arguments...

[bsas]

Hi @webportal,

You could try to use SUMX or you can use multiply OR - it looks like OR( value1, OR(value1, value2))

[Anonymous · Accepted solution]

Also, an alternative to using the OR function that bsas suggested is to use || for the Or component. This will allow you to layer up multiple OR conditions, while the OR DAX Function only allows two variables to be compared.

[Anonymous]

This is one way to do it

Measure = 
CALCULATE (
    ABS ( SUM ( 'BalanceteGeral'[Saldo] ) ),
    FILTER(BalanceteGeral, BalanceteGeral[Conta] >= 11),
    FILTER(BalanceteGeral, BalanceteGeral[Conta] <= 13)
)

A few alternatives to this could be applied, however would imagine for the situation you presented this should work.