Forum Discussion

batespm's avatar
batespm
New Member
2 years ago

Attendance Data

Hi,   I have the below dax for attendance figure.   CBL Attendance % = DIVIDE(     SUM('WorkingArea TOUR_ClassBased'[Positive Marks]),     SUM('WorkingArea TOUR_ClassBased'[Total Marks]) ) ...
Rupak_bi's avatar
Rupak_bi
Super User
2 years ago

If you have a week number column in the table, you may try below

attendance% = 

var positivemarks= sumx(topn(3, table, week number),positive marks)

var totalmarks= sumx(topn(3, table, week number),total marks)

return
positivemarks/totalmarks

 

you may use same concept if you have date cloumn to get last 21 days value.