Forum Discussion
Calculation with OR
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.
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
3 Replies
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