Forum Discussion

jmiridium's avatar
jmiridium
Icon for Helper IV rankHelper IV
9 years ago
Solved

CALCULATE and FILTER With Text

How do I add a column using CALCULATE and FILTER with text results? Urgent
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago
    Failed = CALCULATE(
    COUNT(ComputerStatus[Acrobat]),
    LEFT(ComputerStatus[Acrobat], 6) = "FAILED")
)

    Try this.

     

jmiridium's avatar
jmiridium
Icon for Helper IV rankHelper IV
9 years ago

Yes. It's actually Failed then various resons

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Then i think LEFT([YourField], 6) = "FAILED" will work for you.

  • jmiridium's avatar
    jmiridium
    Icon for Helper IV rankHelper 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's avatar
      Anonymous
      Not applicable
      9 years ago
      Failed = CALCULATE(
    COUNT(ComputerStatus[Acrobat]),
    LEFT(ComputerStatus[Acrobat], 6) = "FAILED")
)

      Try this.

       

      • jmiridium's avatar
        jmiridium
        Icon for Helper IV rankHelper IV
        9 years ago

        That did it thank you!