Forum Discussion

Icon for Helper IV rank

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.

Icon for Helper IV rank

Helper IV

9 years ago

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

Icon for Helper IV rank

Helper 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
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
  Helper IV
  9 years ago
  Yes. It's actually Failed then various resons
  - Anonymous
    Not applicable
    9 years ago
    Then i think LEFT([YourField], 6) = "FAILED" will work for you.