Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Matrix with qualitative value

Hi,

 

I have a table like this for quality chech with different criterias for assessments. and I need to know for each criteria how many of them are satisfactory and not satisfactory. my table is like below which shows the restult for each ID and each criteria.

 

and the result I'm looking for is sth like this which I created in excel. 

 

I'm quite confused how can I make that visual in power bi?