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...
You cannot use HASONEVALUE in that situation.
Instead, create a table variable that applies your filters, and adds the number of "currently on roll") field. Then filter that table variable by the field being equal to 1, and then return the countrows of that.