Hello,
I have been running into a bit of a wall lately, and seems others are two, when using survey data in powerBI. My problem is that I need to weight my data by case (respondent). I have a variable in my table which is the weight each respondent carries (their sum adds up to the total number of responsdents). I need to use this to up or down weight each respondent when I plot questions so our data matches targets (such as nat rep samples). I realise this isnt very straightforward in BI and most of my responses are not numerical (ie. are yes, no, male, female etc.).
Does anyone have any suggestions for the best way to go about weighting my variables in BI? Currently I am trying to follow the solution in https://community.powerbi.com/t5/Desktop/case-weighting-in-data/td-p/51599, but having very little luck getting it to work on a simple column chart showing percentages of those male and female. Using this DAX code:
GenderWeightedMeasure = SUMX('Demographics and Single Punch Questions', 'Demographics and Single Punch Questions'[Weight.Weight] * 'Demographics and Single Punch Questions'[DUM_GENDER_ALT]) / SUM('Demographics and Single Punch Questions'[Weight.Weight])
This is something thats very common in market research and very easy to implement in other packages such as SPSS and Q, so seems strange theres no option to weight by case here.
Any help or advice would be very much appreciated!
