Adding a column to show percentage calculated from columns, Matrix

[JohnDahis]

Good day.

A table shows the Students having their subjects registered for Exams, but not of them were taken.

I want to use Matrix and add a column to show the exam taken rate over the register, i.e. numbers in the 3rd column divided by those in the second.

Tried to figure it out but stuck. Grateful if I can get some advises. Thank you.

Screenshot and attachment (link to DropBox) ready.

[Gordonlilj]

Hi,

I created this measure and it seems to work fine,

DIVIDE(Count(Sheet2[Exam taken]),COUNT(Sheet2[Registered Exam]))

Just change the format to percentage

[JohnDahis]

@Gordonlilj  thank you for the help. but it gives me 100% for each.

any chance to have a look again? thanks.

[Gordonlilj · Accepted solution]

I used the subject and exam taken columns instead of the calculated columns to get the results

[JohnDahis]

@Gordonlilj thank you for the follow-up.

nicely done!