Create matrix with static columns

[AbhiShake]

I have a data table that follows the following format:

Source	Status	Count
A	Completed	10
A	TO-DO	2
B	In-Progress	5
B	TO-DO	5
B	Completed	10
C	COMPLETED	6

There are 4 possible values in status: "COMPLETED", "IN-PROGRESS", "TO-DO", "FAILED"

Sometimes one of the above status values will not be in the data table. In this example, "FAILED"

I want to create a matrix with static columns for the status values.

So for the above table, I want to create a matrix that looks like the following

Source	COMPLETED	IN-PROGRESS	FAILED	TO-DO
A	10	0	0	2
B	10	5	0	5
C	6	0	0	0
D	0	0	0	0

Currently my matrix displays the above table without the "FAILED" column since this value doesn't appear in the data table.

How can I create a matrix with static columns to display "COMPLETED", "IN-PROGRESS", "FAILED", "TO-DO" ?

[ryan_mayu · Accepted solution]

@AbhiShake 

mannually created a status dim table and create relationship between the tables.

then create a measure

Measure = sum('Table'[Count  ])+0

pls see the attachment below