Count occurrences

[dw700d]

I have two tables, a project table and a task table.  The project table contains 6 different projects. The task table contains any project that has a task. I would like to create a measure that calculates the total count of all tasks associated with each project name on the Project Table. Projects that do not have a task(currently not on the task table) should be assigned a 0 . For example Water works has two tasks because it has "task A" & "Task B" but Moon has 0 because it is not on the Task table. My desired outcome is at the bottom

Project Table

Project Name

Water works

Samsung

Intel

Moon

Conway

Earth

TASK TABLE

Project Name	Task
Water works	A
Water works	B
Samsung	C
Samsung	D
Samsung	E
Conway	F

Desired Outcome

Project Name	TASK
Water works	2
Samsung	3
Intel	0
Moon	0
Conway	1
Earth	0

[amitchandak · Accepted solution]

@dw700d , One is you can join project and task table on project name and create a measure

count(Task[Task])+0

And display it with project name from project

or create a new column in project

tasks = countx(filter(Task, task[project name] = project[project name]) , Task[Task]) +0