CALCULATE and FILTER With Text

[jmiridium]

How do I add a column using CALCULATE and FILTER with text results? Urgent

[rventura]

Completed = 
CALCULATE(
    COUNTROWS(incidents),
    FILTER(incidents, incidents[Ticket Status] = "Completed"),
    FILTER(incidents, incidents[Location] = locations[Location])
)

[jmiridium]

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

[jmiridium]

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]

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]

Yes. It's actually Failed then various resons

[Anonymous]

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

[jmiridium]

Would this be the correct complete syntax?

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

[Anonymous · Accepted solution]

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

Try this.

[jmiridium]

That did it thank you!