DAX: How to count rows with correlations to another row? -

-

being new dax, having trouble formulating question , solution related counting rows question-answer pairs.

the general scenario tabular bi model models surveys having question , answer pairing 1 question may have 1 n response options. fact table's key data respondent, response. table references 'question answer' table holding answer details of answer salient data. table in turn references question table holds information question.

i trying solve query of form, how many people answered question x, did not answer question y? in other words, of people answering question 1, how many did not answer question 12?

when question not answered, there no row question response in fact table.

i have been trying create measure fact table, survey response, , believe requires calculate() operations. video @ http://msbiacademy.com/?p=3491 has promising leads, can't quite on hump, in part because creates duplicate table product subcategory , not sure if through importing table twice, , because uses userrelationship. perhaps in case import question twice doesn't make sense. not using slicers may part of difference.

the measure directed primary top level entity survey.

the environment vs 2013 tabular bi model, sql server 2012, excel 2013.

first base measure count answers in fact table.

numanswers := countrows ( factresponse )

second, explicit measure count answers questionid 1. replace hard-coded measure measure tied disconnected slicer choose particular question x.

q1answers := calculate ( [numanswers], questions[questonid] = 1 )

finally, filter subset of people did not answer question 3 (or again, disconnected slicer measure choose question y.)

didntanswerq3 := calculate (     [q1answers],     filter (         values ( respondent[respondentid] ),         calculate ( [numanswers], questions[questonid] = 3 )             = 0     ) )

Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

python - NameError: name 'subprocess' is not defined -

-
i'm trying make rng website: http://jamesdotcom.com/?p=417 . when run following code: captureimage = subprocess.popen( [ "fswebcam", "-r", "356x292", "-d", "/dev/video0", "static.jpg", "--skip", "10" ], stdout=devnull, stderr=devnull) captureimage.communicate() i following error message: nameerror: name 'subprocess' not defined what should do? thanks have imported first? import subprocess captureimage = subprocess.popen(["fswebcam", ...) subprocess included in python standard library since python 2.4. should not necessary install it.
Read more