Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
I used the subject and exam taken columns instead of the calculated columns to get the results
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
@Gordonlilj thank you for the help. but it gives me 100% for each.
any chance to have a look again? thanks.
I used the subject and exam taken columns instead of the calculated columns to get the results
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |