This project has moved. For the latest updates, please go here.

Analyizing survey results, how do I get data for subsets with more than four entries?

Dec 12, 2013 at 3:19 PM

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]

    && ('FactS1Data'[Survey]="1A"),

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?