Forum Discussion
Count occurrences
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 |
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
1 Reply
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