Forum Discussion

MrMike's avatar
MrMike
Icon for Helper II rankHelper II
5 years ago
Solved

Filter and not in filter

What is the DAX synax to count how many students requested but didn't supply the essay.   I tried this but I know its is wrong.  Students Missing Essay = CALCULATE(DISTINCTCOUNT(ACTIVITY_LOG[STUD...
Help required
  • AmedeoM's avatar
    AmedeoM
    5 years ago

    Hello,

     

    please try this measure and let me know if it works:

    Measure :=

VAR _StudentsWithoutEssay = 
	CALCULATETABLE (
		VALUES ( ACTIVITY_LOG[STUDENT_ID] ), 
		ACTIVITY_LOG[ACTIVITY_DESCRIPTION] = "No Essay"
	)

VAR _Result = 
	CALCULATE (
		DISTINCTCOUNT ( ACTIVITY_LOG[STUDENT_ID] ), 
		ACTIVITY_LOG[ACTIVITY_DESCRIPTION] = "Requested Assignment", 
		NOT ACTIVITY_LOG[STUDENT_ID] IN _StudentsWithoutEssay
	)

RETURN
_Result
MrMike's avatar
MrMike
Icon for Helper II rankHelper II
5 years ago

I tired your example and I get a syntex error on both Descriptions words. The error says "The function expects a table expression for argument '', but a string or numeric expression was used."

Martin125's avatar
Martin125
New Member
3 years ago

Essays can be a rewarding and challenging type of writing and are often assigned either to be done in class, which requires previous planning and practice (and a bit of creativity) on the part of the student, or as homework, which likewise demands a certain amount of preparation