I need to count occurrences of 1 column based on multiple filters

[tklausmeier]

I'm new to Power BI. I am building analytics tools to display my software development team's progress in the sprint. I have Tasks with ID's attached to a Parent Project with an ID. Each Task has a State (New, Active, Resolved, or Closed). I have already solved for counting the total number of Tasks per Parent Project. But now I need help solving for how many tasks per parent project are in Closed Status. Below is an example of what my data looks like. Can someone please help point me in the right direction? 

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-cherch-msft · Accepted solution]

Hi @tklausmeier

You may refer to below dax to create the calculated column. You may add +0 for it if you don't need blank rows.

ClosedTasksPerParent =
COUNTROWS (
    FILTER (
        Table,
        Table[ParentID] = EARLIER ( Table[ParentID] )
            && Table[TaskState] = "Closed"
    )
)

Regards,

Cherie

[tklausmeier]

Thanks so much! That worked perfectly! 🙂