Forum Discussion
DAX error support - True/False
I am trying to create a DAX formula that will count the number of students on roll in a school last school year specifically on 2MAY24. Gemini has offered the below but I'm getting a The True/Fal...
Poojara_D12
Super User
Super UserHi karenHO
Can you please try the below dax:
KH Students on Roll 23/24 =
CALCULATE(
COUNTROWS(STUDENT_SCHOOL_ENROLEMENTS), -- Counts students currently on roll
STUDENT_SCHOOL_ENROLEMENTS[CURRENTLY_ON_ROLL] = TRUE, -- Filters students currently on roll
ACADEMIC_CALENDAR_DATES[DATE] = DATE(2024, 5, 2) -- Filters for the specific date 2-May-2024
)Please let me know if it works for you.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
This one has sort of worked, however it is only bringing those students who were 'currently on roll' on 2MAY24.
I want to know all students that were 'currently on roll' on 2MAY24, not just those that were first enrolled on 2MAY24.
any ideas?