Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |