Forum Discussion

markovuc's avatar
markovuc
Regular Visitor
2 years ago

What is the error? Pls help

Why SUMX measure with division calculation by row is different than divison formula results. For cheese for intance SUMX measure is 154,01 and for pure divide formula 43,17%.Where is the catch? Pls explain me. Many thanks

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    SUMX is going to sum all the DIVIDE values. That is sum percentages of each individual rows in the category not the overall percentage. If you added an attribute to the table from the fact table, you would see the individual rows to make up the totals.

     

    What is the goal of the measure SUMX?

    • markovuc's avatar
      markovuc
      Regular Visitor
      2 years ago

      Goal was to write alternative code. 😞☹️ Thanks for the answer.