Forum Discussion

Helper IV

9 years ago

Solved

CALCULATE and FILTER With Text

How do I add a column using CALCULATE and FILTER with text results? Urgent

Anonymous

9 years ago

Failed = CALCULATE(
    COUNT(ComputerStatus[Acrobat]),
    LEFT(ComputerStatus[Acrobat], 6) = "FAILED")
)

Try this.

Helper IV

9 years ago

Would this be the correct complete syntax?

Failed =
CALCULATE(
COUNT(ComputerStatus[Acrobat]),
FILTER(ComputerStatus, ComputerStatus[Acrobat] = LEFT([YourField], 6) = "FAILED"))

Anonymous

Not applicable

9 years ago

Failed = CALCULATE(
    COUNT(ComputerStatus[Acrobat]),
    LEFT(ComputerStatus[Acrobat], 6) = "FAILED")
)

Try this.