multiply two columns doens't work - DAX

[Least123]

When I try to multiply two columns the results for line is diferent when I do this with this two columns in a calculator.

Bellow the two columns and  the result when I try to multiply in a dax.

Dax:

producao_pluma = CALCULATE( [peso_colhido_algodao] *0.41)

r$/kg =  CALCULATE(AVERAGE('f_Resumo Algodão'[R$/kg]))

receita_algodao_pluma2 = producao_pluma]* [r$/kg]

[v-zhangti]

Hi, @Least123 

You can try the following methods.

r$/kg =
CALCULATE ( AVERAGE ( 'f_Resumo Algodão'[R$/kg] ), ALL ( 'f_Resumo Algodão' ) )

The rest of the formula remains unchanged.

Best Regards,

Community Support Team _Charlotte

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

[tamerj1]

Hi @Least123 
Pleasr try

receita_algodao_pluma2 =
SUMX ( VALUES ( 'Table'[Slicing by Colmumn] ), [producao_pluma] * [r$/kg] )

[Least123]

I tried this. Look at the same.