is just a simple measure that is linked to a slicer to select which weighting scheme to use (unweigthed, using Q, or using Q.Įach row of Q is a question response for a single respondent of the survey. Q - Numeric - An alternative response, and what the above metric is actually determining the SD on Q - Numeric - A numeric response to the question Q - numeric - Some questions have multiple iterations, so this is storing this YSD (Q):=SQRT(SUMX(ADDCOLUMNS(ADDCOLUMNS(ADDCOLUMNS(Q,"Mean",Calculate(,All(Q),Q=Earlier(Q),Q=Earlier(Q))),"Delta",(Q - )^2),"wDelta", * SWITCH(,1,1,2,3,)),AVERAGE())/)Ī few things to call out on the data structure: I did manage to get a measure that yields the proper value, however it is incredibly slow at calculating, likely due to it effectively generating the weighted mean for each row of data to calculate the variance. Thanks again, GDRIII - I read through that article earlier, however not sure there is much I can use for this application.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |