Calculation with OR

[Anonymous]

I want to calculate the following measure:

Calculate the total number of people last year with or conditions.

Ex: Total Number = CALCULATE(COUNT(Table[Total]), YEAR(Table[DATE])=YEAR(TODAY()-1) && (Table[REASON]="Not well" or "Left the job") && Table[Gender]="F"))

I am not sure about my OR part of the measure as it thrown an error.  Basically, what I am trying to calculate is total number which is based on last year and if Reason = Not well or left the job and Gender = Female. 

[Anonymous · Accepted solution]

Hey @Anonymous

The OR clause should look like:

(Table[REASON]="Not well" || Table[REASON]="Left the job")

Hope this helps,

Parker

[Anonymous · Accepted solution]

Hi @Anonymous

As mentioned @Anonymous, the OR syntax needs to be changed. Also, the last year part wont retun as expected in your code, you need to change the code as below:

Total Number = CALCULATE(COUNT(Table[Total]), 
      YEAR(Table[DATE])=YEAR(TODAY())-1  
      && (Table[REASON]="Not well" ||Table[REASON]="Left the job") 
      && Table[Gender]="F"))

Thanks

Raj

[Anonymous]

Thank you @Anonymous @Anonymous!

[Anonymous · Accepted solution]

Hey @Anonymous

The OR clause should look like:

(Table[REASON]="Not well" || Table[REASON]="Left the job")

Hope this helps,

Parker