cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RRosen Frequent Visitor
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
Iamnvt Member
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
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
        )
    )
RRosen Frequent Visitor
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."

 

 

Iamnvt Member
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 ) )

 

RRosen Frequent Visitor
Frequent Visitor

Re: Problems with multiple filter

thank you ! it worked fine!


Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

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

Top Ideas
Users Online
Currently online: 55 members 1,141 guests
Please welcome our newest community members: