I am new to DAX and powerpivot, so please bear with me.
I have been trying to create a measure that shows data only where there are at least 5 responses for a particular program. My initial attempts still result in totals where fewer than five responses are given for the particular program.
a few notes about the question involved:
[Q1] is the question response (many responses possible anything over 9000 should be skipped)
[Survey] has two possible values for different surveys.
there should be at least 5 responses per [programcode] and [survey] .
This was my first attempt, it seemed to work (somewhat) in powerpivot, except that it still gave me responses for programs with fewer than 5 responses (I get an error trying to evaluate this formula in DAX studio]
Also tried (and a few variations on this theme) this modifying information I found in the DAX Studio quick tutorial:
"Program_Q1_Resp", countrows(filter( 'FactS1Data'[ProgramName],'FactS1Data'[ProgramName] = "Informatics" && 'FactS1Data'[Survey]= "1A" && 'FactS1Data'[Q01] <9000))
Anyone have any idea what I am doing wrong here?