Adding two column values, one with a string, the other a boolean

[android1]

Hi,

I have two columns I'd like to add if both conditions are met.

If CallSource = "Call" and RecNum is True then I want to count this as 1.

LLL = COUNTROWS(FILTER(Table_Calls,Table_Calls[Callsource] = "CALL"))

How do I add the RecNum is True to this?

Thanks,

android1

[jthomson · Accepted solution]

Try:

calculate(countrows(Table_Calls),Table_Calls[Call_Source]="CALL",Table_Calls[RecNum]=TRUE())