What is the best method to distinct count repeated data from another column

[punksterz626]

Hello All,

I'm hoping someone can guide me the best method to achieve this result.

Table below shows a list of job numbers with multiple tasks and task statuses. I want to tally up all the indvidual task statuses based off the individual job number.

So jobs 1-3 

Result: 

Task A = 2 Jobs Completed 

Task A = 1 Job Incomplete

Task B = 1 Job Completed

Task B = 1 Incomplete

Task B = 1 Pending

Task C = 2 Pending
Task C = 1 Completed

So I want couple of measure that would say something like the following:
Task A Total Jobs in Completed status =2

Task A Total Jobs in Incomplete status = 1

I'm actually contemplating unpivot the task columns in power query so that they're individual task columns; however, my data has MANY tasks so i'm not sure if thats even worth considering.

Any help would be greatly appreciated.

[ebeery · Accepted solution]

@punksterz626 the simplest approach would be to just create a "Jobs" measure:

Jobs = DISTINCTCOUNT('Table'[Job No])

And then use that measure in a matrix visual: