Counting occurrences with 2 filters

[tklausmeier]

I am new to Power BI and I am building progress charts for our software development team. I have a table of tasks that all belong to parent projects. Some of the tasks are Closed and some are New or Active. I've already solved for counting how many tasks exist within each parent project. But now I need to solve for counting how many of the tasks within each parent project are closed. I am doing this so that we can show the percentage completion on each project. So if a project has 4 tasks, 2 are closed, then the graph will show it at 50% completion. This is an example of what my data looks like... 

TaskID	ParentID	TaskState	TasksPerParent	ClosedTasksPerParent
5810	5683	Closed	4	HELP ME
5809	5683	Closed	4
5815	5683	Closed	4
5811	5683	Closed	4
5806	5684	Closed	7
5807	5684	Closed	7
5867	5684	Closed	7
5813	5684	Active	7
5873	5684	Closed	7
5808	5684	Closed	7
5868	5684	Closed	7
5804	5685	Closed	2
5805	5685	Closed	2
5797	5686	Closed	1
5802	5688	Closed	2
5803	5688	Closed	2
5819	5689	Active	7
5880	5689	New	7
5879	5689	Active	7
5881	5689	New	7
5882	5689	New	7
5820	5689	Active	7
5821	5689	Active	7

[v-yuta-msft · Accepted solution]

Hi tklausmeier,

To achieve your requirement, create a calculate column using DAX below:

Result = CALCULATE(COUNT(Table1[TaskID]), FILTER(ALLEXCEPT(Table1, Table1[ParentID]), Table1[TaskState] = "Closed"))

  

Regards,

Jimmy Tao