But be careful, I think that only works right if your weights sum up to the total n of cases in your table. Here is the mean of 1, 2, 3 and 4: weighted average equal. 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). When we do a simple mean (or average), we give equal weight to each number. I realized that this 'workaround' was only necessary for displaying such an average value.

MyWeightedMeasure = SUMX('TableName' 'TableName' * 'TableName') / SUM('TableName') Like most spreadsheet programs MS Excel has a random number. so in my case the formula I needed was, for displaying the average of a scale value (index value, ranging from 0 to 100): Exercise 1: The mechanics of random assignment using MS Excel. I want to optimize these weights to revamp our scoring mechanism using some data oriented approach to achieve a more relevant score. Weights cannot be negative, though they can be zero. Thanks in after a few trials and errors, and googling the DAX formulas, I might have worked it out. Currently the score is calculated based on assigning weights on these parameters(Say 10 to var1, 20 to var2 and so on), and these weights are determined based on our gut feeling. May refer to a range of cells, or may contain the weights themselves. With our tool, you can make your sample representative for any population. Does anyone have any thoughts as to why this might be happening, and how to work around it? All you have to do is: Upload the data set containing your sample Enter what the targets are supposed to be of your population And the tool does the rest for you makes it easy and even fun to weigh your data. I've been trying to use for my gender question, but get an error whenever I put the measure in the values bucket as suggested. Bumping this, as I have been trying to follow your suggestion for using when frequencies of groups are represented by different names in the a column.

Assigning weights to variables in excel