Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Grouping column

Hi! I need to create a formula, when I will use an existing table but with grouping, how can I do it?
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    Please try this

    Total Scores =
SUMX (
    DISTINCT (
        SELECTCOLUMNS (
            CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[question] ) ),
            "@question", [question],
            "@score", [score]
        )
    ),
    [@score]
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

this is a very general question. Would you please provide more details about your data structure and the expected results. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Cognitive ease = SUMX(Filter(table , table[question] = "first_question"), table[score])

That is my formula, I need to some how add grouping that I need