Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How do I add a column using CALCULATE and FILTER with text results? Urgent
Solved! Go to Solution.
Failed = CALCULATE( COUNT(ComputerStatus[Acrobat]), LEFT(ComputerStatus[Acrobat], 6) = "FAILED") )
Try this.
Completed = CALCULATE( COUNTROWS(incidents), FILTER(incidents, incidents[Ticket Status] = "Completed"), FILTER(incidents, incidents[Location] = locations[Location]) )
Too many arguments were passed to the COUNTROWS function. The maximum argument count for the function is 1.
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"))
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.
Yes. It's actually Failed then various resons
Then i think LEFT([YourField], 6) = "FAILED" will work for you.
Would this be the correct complete syntax?
Failed =
CALCULATE(
COUNT(ComputerStatus[Acrobat]),
FILTER(ComputerStatus, ComputerStatus[Acrobat] = LEFT([YourField], 6) = "FAILED"))
Failed = CALCULATE( COUNT(ComputerStatus[Acrobat]), LEFT(ComputerStatus[Acrobat], 6) = "FAILED") )
Try this.
That did it thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |