Forum Discussion
Solved
Distinct Count Goal as completed when all Task Status is marked as completed
Good Day BI generals, what approach and dax function can i use to solve this challenge on my subject (distinct count Goal as completed when all Task is marked as completed ), Below is a dummy table i...
pls try this
unique goal = DISTINCTCOUNT('Table'[GOALS]) Complete goals = [unique goal]-CALCULATE(DISTINCTCOUNT('Table'[GOALS]),FILTER('Table','Table'[Task STATUS]<>"Completed"))
pls try this
unique goal = DISTINCTCOUNT('Table'[GOALS])
Complete goals = [unique goal]-CALCULATE(DISTINCTCOUNT('Table'[GOALS]),FILTER('Table','Table'[Task STATUS]<>"Completed"))