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] )
tamerj1
Community Champion
Community ChampionAnonymous
Please try this
Total Scores =
SUMX (
DISTINCT (
SELECTCOLUMNS (
CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[question] ) ),
"@question", [question],
"@score", [score]
)
),
[@score]
)It's very good solution, but, what if instead of sum, I need average, when I just put averagex, it works wrongly