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. 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

     

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous 

      Please try this

      Total Scores =
SUMX (
    DISTINCT (
        SELECTCOLUMNS (
            CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[question] ) ),
            "@question", [question],
            "@score", [score]
        )
    ),
    [@score]
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        It works for now, I need to do it couple times for some cases, but thanks a lot!!!