When Sum Formula goes wrong

[Sergiocampos]

Hello, how are you?

I have a small problem with a formula.

I have a slightly extended base on which I am performing a margin test, everything was fine until I tried the following formula:

i.Margin = sumx ('Final ad base', 'Final ad base' [i.cmvv] + 'Final ad base' [i.vendas])

the result was this:

Clearly the result should not be this, could someone help me fix and explain what went wrong with the formula?

Best Regards

[Ashish_Mathur]

Hi,

If i.cmvv and i.vendas are columns (and not measures) in the Final ad base table, then this measure should work

='Final ad base' [i.cmvv] + 'Final ad base' [i.vendas]

Hope this helps.

[Sergiocampos]

Hi Ashish thanks for the answer!

Ok, i tried it and the result is the same, pretty strange no?

Reggards

[mahoneypat]

Is your Fam_Item column on the same table with the columns you are SUMming?  If not, what is the relationship between them?

Regards,

Pat

[Sergiocampos]

Yes, is the same file, it's only one base.

Farm_item is a classification of the items:

CMV another column with values;

R$ total is another column with values.

i tried sumx with calculate, tried also create a new column with SUMX Farm_item, tried do just the sum and still not working.

Best Reggard

[v-easonf-msft]

Hi, @Sergiocampos 

What is your expected result?

Can you show the value of the column'Final ad base' [i.vendas] in the screenshot?

In addition, please check if there is something wrong with the format of the measure i.Margin.

Best Regards,
Community Support Team _ Eason