Matrix Visual

[Sudhavi_84]

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)

[Sudhavi_84 · Accepted solution]

Please ignore I acheived it.

[v-yiruan-msft]

Hi @Sudhavi_84 ,

Could you please mark your post as Answered since it has been resolved? Thank you.

Best Regards