Forum Discussion

dani42's avatar
dani42
Regular Visitor
10 years ago
Solved

case weighting in data

Hello,   as I am working in market research, our data which is always a sample from the population, is often weighted (nearly always). In statistical programs such as SPSS, one can define a variabl...
  • dani42's avatar
    dani42
    9 years ago

    Okay, after a few trials and errors, and googling the DAX formulas, I might have worked it out. so in my case the formula I needed was, for displaying the average of a scale value (index value, ranging from 0 to 100):

     

    MyWeightedMeasure = SUMX('TableName'; 'TableName'[WeightColumnName] * 'TableName'[ColumnName]) / SUM('TableName'[WeightColumnName])

     

    I realized that this "workaround" was only necessary for displaying such an average value. For percentages, i.e. frequencies of groups that are represented by different names in one column, such as "male/female", you only need to put your column in the legend field, and your weight column in the value-field (I'm in the german version, I hope I translated the words correctly). But be careful, I think that only works right if your weights sum up to the total n of cases in your table.

     

     

Nhallquist's avatar
Nhallquist
Helper V
10 years ago

What have you tried so far?  This is a bit outside my "sweet spot", but I would recommend looking at R to do some of this for you.  There is R integration for PowerBI and I think that is where you will get this type of functionality.  Use this Link to get started.  

 

 

dani42's avatar
dani42
Regular Visitor
10 years ago

Thanks for your suggestion. In R, weighting cases seems to be a bit more difficult than it is in SPSS, where you simply type "weight by var" and you're done. Also, if Power BI doesn't has weighting implemented, then I could also switch completely to R, I think. But my experience with both of the programs is very little...