Totals

Question

New to Power BI.&nbsp; I have 20 students that have to take 4 classes to meet training requirementsI'm trying to calcuate the percentage of students that have completed 0,1,2,3 or 4 classesIs there a way to could the total column based on criteria (0,1,2,3,4) and divide by the total number of students.&nbsp;Thanks in advance&nbsp;&nbsp;&nbsp;Class #1Class #2Class #3Class #4Total&nbsp;&nbsp;&nbsp;Student #311114&nbsp;&nbsp;&nbsp;Student #13&nbsp;1113&nbsp;&nbsp;&nbsp;Student #4&nbsp;1&nbsp;12&nbsp;&nbsp;&nbsp;Student #51&nbsp;1&nbsp;2&nbsp;&nbsp;&nbsp;Student #81&nbsp;1&nbsp;2&nbsp;&nbsp;&nbsp;Student #15&nbsp;11&nbsp;2&nbsp;0 class40%Student #171&nbsp;&nbsp;12&nbsp;1 class20%Student #19&nbsp;11&nbsp;2&nbsp;2 class30%Student #21&nbsp;&nbsp;&nbsp;1&nbsp;3 class5%Student #7&nbsp;1&nbsp;&nbsp;1&nbsp;4 class5%Student #111&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;Student #12&nbsp;&nbsp;1&nbsp;1&nbsp;&nbsp;&nbsp;Student #1&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;Student #6&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;Student #9&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;Student #10&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;Student #14&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;Student #16&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;Student #18&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;Student #20&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;

mattallington · Accepted Answer

You need to unpivot the data in the query editor so it has the following columns

student name, class name, value

when you have these three columns, you can just drag the columns Into your report and get the total column (put value column in the values section). Then write some measures such as

classes completed = sum(table[value])

total students = distinctcount(table[student name])

0 class = divide(sumx(values(table[student name]),[classes completed]=0),[total students])

repeat for 1,2 etc

Forum Discussion

Totals

2 Replies

Related content

Cumulative Total

% of total measure

Running Totals

DAX total != total rows

Total of Measure

	Class #1	Class #2	Class #3	Class #4	Total
Student #3	1	1	1	1	4
Student #13		1	1	1	3
Student #4		1		1	2
Student #5	1		1		2
Student #8	1		1		2
Student #15		1	1		2	0 class	40%
Student #17	1			1	2	1 class	20%
Student #19		1	1		2	2 class	30%
Student #2	1				1	3 class	5%
Student #7		1			1	4 class	5%
Student #11	1				1
Student #12			1		1
Student #1					0
Student #6					0
Student #9					0
Student #10					0
Student #14					0
Student #16					0
Student #18					0
Student #20					0