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

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

Try this.

9 Replies

rventura
Frequent Visitor
9 years ago
Completed = CALCULATE( COUNTROWS(incidents), FILTER(incidents, incidents[Ticket Status] = "Completed"), FILTER(incidents, incidents[Location] = locations[Location]) )
- jmiridium
  Helper IV
  9 years ago
  Too many arguments were passed to the COUNTROWS function. The maximum argument count for the function is 1.
  - jmiridium
    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"))