Measured Total Problem.

[Anonymous]

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.

[sturlaws · Accepted solution]

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] )
)

[sturlaws]

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.

[Anonymous]

Hi @sturlaws 

Just for your info ,brüt cb satış calculation works well except total sum.

Code as follow :

[sturlaws · Accepted solution]

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] )
)

[Anonymous]

@sturlaws  thank you so much. problem solved

[sturlaws · Accepted solution]

and just a little tip, when sharing code(and data), paste the code/data instead of screenshots