Forum Discussion
Measured Total Problem.
Dear All,
When I searched about problems that is related to measured total problem, I have seen many solutions but that does not work for my problem. Although I have wrote a formula based on a logic ( this works well.) total sum of measured formula is wrong. As you see below, "brüt cb.satış" column's total is 2,006 but it should have been 2773. Can you help me ?
formula that I wrote to fix wrong total but does not work
Best Regards.
sorry, I obviously did not manage to post in the code in my previous post. Here it is:
measure = IF ( HASONEVALUE ( [code] ), [brut], SUMX ( SUMMARIZE ( 'table', [code], [surname] ), [brut] ) )and just a little tip, when sharing code(and data), paste the code/data instead of screenshots
5 Replies
Hi, Anonymous,
without knowing the code for [brut cb satis], it's difficult to suggest an exact solution.
You could try to rewrite your code to this:
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.Hi sturlaws
Just for your info ,brüt cb satış calculation works well except total sum.
Code as follow :
sorry, I obviously did not manage to post in the code in my previous post. Here it is:
measure = IF ( HASONEVALUE ( [code] ), [brut], SUMX ( SUMMARIZE ( 'table', [code], [surname] ), [brut] ) )