Forum Discussion

karenHO's avatar
karenHO
Regular Visitor
1 year ago

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...
beginner
DAX
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ALL

Firstly  Poojara_D12  and  lbendlin  thank you for your solution!
And karenHO ,The problem you encountered seems to be because ACADEMIC_CALENDAR_DATES[STUDENT_ON_ROLL] is referenced twice in the dax and is assigned a different value, I tried to improve your DAX as follows, I hope that helps you.

KH Students on Roll 23/24 = 
CALCULATE (
    COUNTROWS ( Student_School_Enrollments_Data ),
    Academic_Calendar_Dates_Data[DATE] = DATE(2024, 5, 2),
    Academic_Calendar_Dates_Data[STUDENT_ON_ROLL] = TRUE,
    Student_School_Enrollments_Data[CURRENTLY_ON_ROLL] = TRUE
)

If you have more recent questions, you can check my pbix file to see if my example data meets your expectations, and I would be honored if my solution solves your problem!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

  • karenHO's avatar
    karenHO
    Regular Visitor
    1 year ago

    Hi Thanks for this.

     

    I have used the below formula but I am now getting an error - A function 'PLACEHOLDER' has been used in a True/Fasle expression that is used as a table filter expressions.  This is not allowed.

     

    Any ideas?

     

    KH Students on Roll 23/24 =
    CALCULATE (
        COUNTROWS (STUDENT_SCHOOL_ENROLMENTS ),
        ACADEMIC_CALENDAR_DATES[DATE] = DATE(2024, 5, 2),
        ACADEMIC_CALENDAR_DATES[Student_On_Roll] = TRUE,
        STUDENT_SCHOOL_ENROLMENTS[CURRENTLY_ON_ROLL] = TRUE
    )