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.

     

rventura's avatar
rventura
Frequent Visitor
9 years ago
Completed = 
CALCULATE(
    COUNTROWS(incidents),
    FILTER(incidents, incidents[Ticket Status] = "Completed"),
    FILTER(incidents, incidents[Location] = locations[Location])
)
  • jmiridium's avatar
    jmiridium
    Icon for Helper IV rankHelper IV
    9 years ago

    Too many arguments were passed to the COUNTROWS function. The maximum argument count for the function is 1.

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

      OK I think I have somewhat of an idea how to get it going. How do I enter a wildcard on a text field?

       

      Example:

       

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

      • 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.