Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have about 200 hundread students atending class and each class they must fill a form. However there are students sending more than once a day and I can not block for one responce a day. how ever i would like to count how my responses or attendences I have.
I have the DAX below however it gives me all the count of responses from forms. So if one student responded 2 times , it count 2 times. How can i change to i can have it count only one per day per student? By the way i calculate the atendence per quater of the year and my students must atend at least 16 times.
M_Q1_Attendance Count =
CALCULATE(
COUNT('礼拝Forms'[Completion time]),
FILTER(
'礼拝Forms',
'礼拝Forms'[Completion time] >= DATE(2023,4,1) &&
'礼拝Forms'[Completion time] <= DATE(2023,6,5)
)
)
Solved! Go to Solution.
Hi,
Assuming the Completion time has Date data type, create a relationship (Many to One and Single) between the Completion time and Date column. To your visual, drag Date from the Calendar Table. Write this measure
Number of students = distinctcount(Data[Student ID])
Hope this helps.
Hi,
Assuming the Completion time has Date data type, create a relationship (Many to One and Single) between the Completion time and Date column. To your visual, drag Date from the Calendar Table. Write this measure
Number of students = distinctcount(Data[Student ID])
Hope this helps.
Thank you so much. it worked just fine.
M_Q1_dist_Attendance Count =
CALCULATE(
distinctcount('礼拝Forms'[Completion time]),
FILTER(
'礼拝Forms',
'礼拝Forms'[Completion time] >= DATE(2023,4,1) &&
'礼拝Forms'[Completion time] <= DATE(2023,6,5)
)
)
@chang_jp . in case Completion time does not have time stamp
else create a date value column first and use that
Completion date = datevalue([Completion time])
M_Q1_Attendance Count =
CALCULATE(
COUNTrows(Summarize('礼拝Forms','礼拝Forms'[Student],'礼拝Forms'[Completion time])),
FILTER(
'礼拝Forms',
'礼拝Forms'[Completion time] >= DATE(2023,4,1) &&
'礼拝Forms'[Completion time] <= DATE(2023,6,5)
)
)
thank you very much for your input. I will try your advice. however the distinctcount worked just fine.
thank you very much for your advice.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
59 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |