Forum Discussion
Conditional Measure
Good Afternoon I am having an issue with finding a DAX and I was hoping someone on here may be able to help me. I have a measure that is working out the percentage attendance of students in a sc...
Anonymous
pls see the attachment below
Present is any Mark on a register for AM it is / and for PM register is \. The L code is Late before Registration which is a present mark but gives us the ability to track the number of lates. The total number of marks is the count of all marks in the column and then the total present including L / by the total to give the % attendance. so if the Period is HT1 then the pts achieved is 100 if the attendance for the period is 100%.
