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.
Hi there.
I have a 'Task' table where I need to count the number of times the text "Not completed" appears in the 'Task progress' column.
The count needs to be limited by the text values of the other table columns 'Critical Task' and 'Overdue' both being "True".
I have tried with COUNTAX() and FILTER, but I never seem to get the correct result.
Any ideas on how to count the number of not completed tasks that are also critical and overdue?
Solved! Go to Solution.
what does your statemetn look like?
test =
CALCULATE (
COUNTROWS ( table ),
FILTER (
table,
table[taskprogress] = "Not Completed"
&& table[CriticalTask] = "True"
&& table[Overdue] = "True"
)
)
Proud to be a Super User!
what does your statemetn look like?
test =
CALCULATE (
COUNTROWS ( table ),
FILTER (
table,
table[taskprogress] = "Not Completed"
&& table[CriticalTask] = "True"
&& table[Overdue] = "True"
)
)
Proud to be a Super User!
Your solution works perfectly!
Can you explain the difference between using the FILTER function and just adding the filters at the end as part of the CALCULATE function?
Like Calculate (expression, filter 1, filter 2, filter 3)
@Anonymous not quite sure what you asking but this should be informative
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
Proud to be a Super User!
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 |
---|---|
108 | |
98 | |
79 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |