Forum Discussion
Helper Iweight average
Hi ellevy,
It sounds like you want to apply multiple aggregates to your expression.
Maybe you can try to add a variable with summarize function to apply the first level aggregate and use the iterator function to do the second summary of these results.Measure Totals, The Final Word
If you confused about the coding formula, please share some dummy data to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Super Userellevy , This sample does noes represent a case of weighted Average.
This is also as good as
sum(Table[q1])/sum(Table[Q1])
If you want to multiple to column in a row your can do in sumx
sumx(Table, [Q1] *[Q2])
Helper IThanks, i used a variation of - sumx(Table, [Q1] *count(ID) ) / SUM (ID) which is good for my case. the weights are the numbers in each Q coulmn (Q1,Q2...) , the numbers i wish to weight are the "count(ID) "
Hi ellevy,
It sounds like you want to apply multiple aggregates to your expression.
Maybe you can try to add a variable with summarize function to apply the first level aggregate and use the iterator function to do the second summary of these results.Measure Totals, The Final Word
If you confused about the coding formula, please share some dummy data to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng