Calculate with more than one filter

[Gelain]

Hello!

How do I apply two or more filters in the same query?

Query= CALCULATE([Valores Totais];'Sintético'[Tipo]="Outros") +CALCULATE([Valores Totais];'Sintético'[Tipo]="Receitas")

Thank you!

[jmalone · Accepted solution]

@Baskar- you are correct that a measure will allow FILTER() function within CALCULATE().

However I believe the suggestion from @tringuyenminh92 will not produce the desired results because it uses an AND (&&) clause and should use an OR ( || ) clause.

So either formula should work in most situations.

Query =
CALCULATE (
    [Valores Totais],
    FILTER ( Sintetico, Sintetico[Tipo] = "Outros" || Sintetico[Tipo] = "Receitas" )
)

Query =
CALCULATE (
    [Valores Totais],
    Sintetico[Tipo] = "Outros"   ||
    Sintetico[Tipo] = "Receitas"
)

[tringuyenminh92]

Hi @Gelain,

you could put them inside filter method:

Query= CALCULATE([Valores Totais],filter(Sintético,'Sintético'[Tipo]="Outros" && 'Sintético'[Tipo]="Receitas" ) )

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen

[Gelain]

Hi @tringuyenminh92!

I installed the latest version of Power BI and only accepted without the filter:

Query = CALCULATE([Valores Totais];('Sintético'[Tipo]="Receitas" || 'Sintético'[Tipo]="Despesas"))

What do you think?

Thank you!

Gelain

[Baskar]

No way . Am 100% sure measure and cal column should allow filter.

one question for do u using any Live connection ?

[jmalone · Accepted solution]

@Baskar- you are correct that a measure will allow FILTER() function within CALCULATE().

However I believe the suggestion from @tringuyenminh92 will not produce the desired results because it uses an AND (&&) clause and should use an OR ( || ) clause.

So either formula should work in most situations.

Query =
CALCULATE (
    [Valores Totais],
    FILTER ( Sintetico, Sintetico[Tipo] = "Outros" || Sintetico[Tipo] = "Receitas" )
)

Query =
CALCULATE (
    [Valores Totais],
    Sintetico[Tipo] = "Outros"   ||
    Sintetico[Tipo] = "Receitas"
)

[Gelain]

@jmalone Thank you!

[Baskar · Accepted solution]

Try this one 

Query =
CALCULATE (
[Valores Totais],
OR (Sintetico[Tipo] = "Outros" , Sintetico[Tipo] = "Receitas")
)

It is not solve your prob share some sample data 

[Gelain]

@Baskar Thank u!