Measure is aggregating the line and not the column in chart

[TI_RB]

In this chart, the column .Dif_Valor (value difference) is a measure which multiply Variação*Vl_Vendas_Atual  (variation* week sales). Variação is measured by (Marg_Atual)-(Marg_Ant) or (margin)-(last week margin).

What I need is for the column Dif_Valor to sum it's values and not make the calculation by lines. Can anyone help me? 

[Anonymous]

Hi @TI_RB ,

Sorry, not very clear. What do you want to sum? Can you give an expected result. Does subtotal want to sum?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TI_RB]

Hi, @Anonymous . I want to sum the subtotal of .Dif_Valor. Currently it's making a calculation by line.

[Anonymous]

Hi @TI_RB ,

The regular solution is to create a new measure and call the original measure.

New measure = SUMX('TABLE', [.Dif_Valor])

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TI_RB]

Didn't work. Result value is 0.

[Anonymous]

Hi @TI_RB ,

Can you share pbix? If the data is private data, you can provide me with dummy data, measures you use and expected results.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.