when adding meassurement it gives me the average and not the sum

[ChecoFloresC]

Hi,  i have a Meassure called " CXI Material MN" this is generad from the division of the 2 colums of a table. What I require is the sum of that messure but  what results is an average.

The result shoul be $0.171 and not $0.043  

Greetings

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.

Piecio Material MIN = 
SUMX (
    VALUES ( Data[Description] ),
    CALCULATE ( MIN ( Data[Precio Material] ) )
)

Yield SUM = 
SUM( Data[Yield] )

CXI material MIN =
SUMX (
    VALUES ( Data[Description] ),
    DIVIDE ( [Piecio Material MIN], [Yield SUM] )
)