What is the error? Pls help

[markovuc]

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

[3CloudThomas]

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]

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