Problems with multiple filter

[Anonymous]

Dear Friends,

I am new to PBI and finding problems in getting the solution above,

I really don´t know if there is a problem with the logic or with the function itself, 

I have tried with if() function but Dax compiler keeps saying that I am not allowed to do such filter or if condition.

thanks and best regards !

testcalculate =

VAR ano =

FORMAT ( YEAR ( MAX ( FatoOpex[Data] ) ) - 3; "####" )

RETURN

CALCULATE(sum(FatoOpex[valor]);

FILTER( FatoOpex;

FatoOpex[exDiretoria] = "0" &&

FatoOpex[DimCalendario.Ano]=ano)

||

FILTER(FatoOpex;

FatoOpex[exDiretoria] = "1" &&

FatoOpex[DimNatureza.idNatureza]="7" &&

FatoOpex[DimCalendario.Ano]=ano))

[jdbuchanan71]

Give this a try

testcalculate =
VAR ano =
    FORMAT ( YEAR ( MAX ( FatoOpex[Data] ) ) - 3; "####" )
RETURN
    CALCULATE (
        SUM ( FatoOpex[valor] );
        OR (
            FatoOpex[exDiretoria] = "0"
                && FatoOpex[DimCalendario.Ano] = ano;
            FatoOpex[exDiretoria] = "1"
                && FatoOpex[DimNatureza.idNatureza] = "7"
                && FatoOpex[DimCalendario.Ano] = ano
        )
    )

[Anonymous]

thank you for your try, but have this :

"The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression."

[Iamnvt · Accepted solution]

hi,

the syntax:

CALCULATE ( <Expression> [, <Filter> [, <Filter> [, … ] ] ] )

treat Filter1, Filter2 with the AND operations.

to use the OR operations, you need to use it within the same filter. 

testcalculate =
VAR ano =
    FORMAT ( YEAR ( MAX ( FatoOpex[Data] ) ) - 3; "####" )
RETURN
    CALCULATE (
        SUM ( FatoOpex[valor] );
        FILTER(FatoOpex; 
           OR (
            FatoOpex[exDiretoria] = "0"
                && FatoOpex[DimCalendario.Ano] = ano;
            FatoOpex[exDiretoria] = "1"
                && FatoOpex[DimNatureza.idNatureza] = "7"
                && FatoOpex[DimCalendario.Ano] = ano
        )
    )

[Anonymous]

thank you ! it worked fine!

---