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

ChecoFloresC — Fri, 21 Jul 2023 00:17:47 GMT

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

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

Jihwan_Kim — Fri, 21 Jul 2023 04:42:05 GMT

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

topic Re: when adding meassurement it gives me the average and not the sum in DAX Commands and Tips

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

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