Forum Discussion
Solved
Distinct Count number of completed Goals when all Task statuses in Goals are marked as completed
Good Day Excel users, what approach and formula can i use to solve this challenge on my subject (Distinct Count number of completed Goals when all Task statuses in Goals are marked as completed ). ...
See the attached version. I added a helper column to the first sheet.
I used formulas that will work in all versions of Excel. It would be easier in Excel 365.
One more option for the collection. It could be done with PivotTable if add data to data model creating it and use couple of DAX measures
Unique Goals :=
DISTINCTCOUNT ( Range[GOALS] )
Completed Unique :=
CALCULATE ( [Unique Goals], Range[Goal STATUS] = "Completed" ) + 0
Resulting PivotTable
Thank you