Add Numerical Values as the result of Multiple If Statements

[Brett007]

I have Three Text Columns:

Status 1

Status 2

Status 3

The common values in all three are "Late", "On-Time", "Complete"

I would like to create a column that shows the count of "Late" from these three columns per row.

This was my last failed attempt:

Late Status = Calculate(Sumx(

If('TableA'[Status 1] = "Late", 1,0)+

If('TableA'[Status 2] = "Late", 1,0)+

If('TableA'[Status 3] = "Late", 1,0))

Thank you

[amitchandak · Accepted solution]

@Brett007 , try like

Late Status = Calculate(countrows('TableA'[Status 1] = "Late")+ countrows('TableA'[Status 3] = "Late") + countrows('TableA'[Status 3] = "Late"))