Forum Discussion
Grouping column
Hi! I need to create a formula, when I will use an existing table but with grouping, how can I do it?
Anonymous
Please try this
Total Scores = SUMX ( DISTINCT ( SELECTCOLUMNS ( CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[question] ) ), "@question", [question], "@score", [score] ) ), [@score] )
Anonymous
By group you mean same question same score? How many groups there are for each question? Are trying to sum the distinct values of scores of the question groups?
Yes, I don't need to sum 3 times 0.21, it will be 0.63, but I need only 0.21. This score is question score, not persons, but it is shown per person, that's the problem
Anonymous
Please try this
Total Scores = SUMX ( DISTINCT ( SELECTCOLUMNS ( CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[question] ) ), "@question", [question], "@score", [score] ) ), [@score] )It works for now, I need to do it couple times for some cases, but thanks a lot!!!
It's very good solution, but, what if instead of sum, I need average, when I just put averagex, it works wrongly
Anonymous
Yes exactly