Filter function not working

[Anonymous]

below function is not working, what could be wrong

ChocoChipsRevenue = CALCULATE(SUM(financials[Revenue]),financials[Country]= "Canada",financials[Country]="France")

[VahidDM · Accepted solution]

Hi @Anonymous 

Try this:
OR:

ChocoChipsRevenue =
CALCULATE (
    SUM ( financials[Revenue] ),
    financials[Country] = "Canada"||
    financials[Country] = "France"
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube