This project has moved and is read-only. 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 4:19 PM
Hello,

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]

=if(
and(
    ('FactS1Data'[Q01]<9000),(counta('FactS1Data'[Q01])>5)
    ) 
    && ('FactS1Data'[Survey]="1A"),

'FactS1Data'[Q01],BLANK())
Also tried (and a few variations on this theme) this modifying information I found in the DAX Studio quick tutorial:

summarize
(
values('FactS1Data'[Q01]),
'FactS1Data'[Q01],
"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?