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.

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Is failed always going to be the first 6 characters?  If so, use LEFT([YourField], 6) = "FAILED".  Failing that there is a function called FIND which returns true or false if it finds a subtext within a larger text.

 

For performance reasons, LEFT is going to be faster but if its not suitable FIND will work in a similar manner to the wildcarding you were hoping for.

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.