reporting comma separated values in one cell

Hey,

you have to split the comma separated values in your table table_review into separate rows to get something like this

id | present

1 | 1

1 | 3

1 | 4

2 | 2

2 | 4

...

Then you can create a relationship between the tables wiht table_role on the one-side and table_review on the many-side.

You achieve this by using the query editor, please have a look at this post

https://community.powerbi.com/t5/Desktop/How-to-split-the-the-Column-into-Multiple-rows/m-p/255014#M113552

 Please be aware that in the above mentioned post the separator "semicolon" is used, just make sure that you choose comma.

In a visual use the column Role as axis and the ID-column from table_review as value, but change the aggregation type from SUM to COUNT by using the context menu on the ID-column after you assigned it to the visual.

Hope this gets you started

Regards

Tom