Matrix Visual

Hi Experts,

I have below table and would like to acheive right side table using Matrix visual.

Its simply Counting the distinct projects from based on Project level.

But for some reason because of duplicates it is counting repeated text as well. But when I select Disticnt it is not working.

Should I write any measures to acheive and count only distinct (colour combination of Project and Project level)