Forum Discussion

nnn123's avatar
nnn123
Regular Visitor
8 years ago
Solved

Aggregating stratified data

Hi,   I'm trying to aggregate some survey results in Power BI. The survey respondents were all split into 4 categories/strata and then a weight applied to the separate stratum before calculating we...
  • jthomson's avatar
    jthomson
    8 years ago

    Make a measure WeightedResult = Calculate(sumx(tablename,tablename[Result]*tablename[weight]))

jthomson's avatar
jthomson
Solution Sage
8 years ago

Make a measure WeightedResult = Calculate(sumx(tablename,tablename[Result]*tablename[weight]))