Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
You will have to excuse me if some of the terminology is not correct but I'm not a programmer by any stretch and I'm trying to teach myself this package so I can make our school data more accessible and transparent.
So after my excuses are done I'll explain my issue.
I have a number of reports running from our School MIS and I want to be able to show all students who have been persistently absent, which is defined as less than 90% attendance, this academic year. I have a table that shows in columns the student ID, their attendance code for every day, so that is a row for every day in this academic year, and the statistical meaning for that code. I then have calculated measures for number of authorised absences, number of present and number of unauthorised absences.
Solved! Go to Solution.
Thanks for the offer but I managed to produce what I wanted with a measure.
PA = SUMX(VALUES(Attendance[External Id]),IF(AND(ISNUMBER(Attendance[%att]),Attendance[%att]<=.9),1,0))/SUMX(VALUES(Attendance[External Id]),IF(ISNUMBER(Attendance[%att]),1,0))
Where External ID is the Unique ID, %att is a measure that calculates their % attendance.
Hi @IanGladden ,
If you don't mind, please share me some sample data or your PBIX file without sensitive information.
Best Regards,
Icey
Thanks for the offer but I managed to produce what I wanted with a measure.
PA = SUMX(VALUES(Attendance[External Id]),IF(AND(ISNUMBER(Attendance[%att]),Attendance[%att]<=.9),1,0))/SUMX(VALUES(Attendance[External Id]),IF(ISNUMBER(Attendance[%att]),1,0))
Where External ID is the Unique ID, %att is a measure that calculates their % attendance.
Thanks for your offer, apologies for the late reply but the email notification went into my junk folder.
I'll produce a sanitised data PBIX file this weekend and send it on to you then.
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |