cancel
Showing results for
Did you mean:
Frequent Visitor

## Problems with multiple filter

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))
1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: Problems with multiple filter

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

4 REPLIES 4
Super User

## Re: Problems with multiple filter

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
)
)```
Frequent Visitor

## Re: Problems with multiple filter

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."

Member

## Re: Problems with multiple filter

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

Frequent Visitor

## Re: Problems with multiple filter

thank you ! it worked fine!

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

#### PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 55 members 1,141 guests
Recent signins: