topic Re: not the same total while averaging in DAX Commands and Tips

not the same total while averaging

Easley08 — Fri, 29 Dec 2023 07:15:16 GMT

Hi,

is there a way to fix this currently i need to combine this measure into 1

the correct out put is Measure which is 64.9

currently im using variable to call the Measure

Finished Lead Cost ULAB = DIVIDE([ULAB Buying PHP/kg],AVERAGE(pb_percent[pb_ulab]),0)+SUM(raw_mats[ulab_php_conversion_cost_kg])-[Plastic Savings / kg]

Measure = AVERAGEX( VALUES('Calendar Table'[Date]),[Finished Lead Cost ULAB])

Finished Lead Cost ULAB1 =

Var Finished Lead Cost ULAB = DIVIDE([ULAB Buying PHP/kg],AVERAGE(pb_percent[pb_ulab]),0)+SUM(raw_mats[ulab_php_conversion_cost_kg])-[Plastic Savings / kg]

var Measure = AVERAGEX(VALUES('Calendar Table'[Date]),Finished Lead Cost ULAB )

RETURN

Measure

why im getting the wrong total when im just using the variable.

Re: not the same total while averaging

Fowmy — Fri, 29 Dec 2023 07:17:06 GMT

Easley08

You cannot use a variable (ans) inside an interation as the variable once assigned behaves like a constant.

Use this meaure:

Finished Lead Cost ULAB1 = AVERAGEX ( VALUES ( 'Calendar Table'[Date] ), CALCULATE ( DIVIDE ( [ULAB Buying PHP/kg], AVERAGE ( pb_percent[pb_ulab] ), 0 ) + SUM ( raw_mats[ulab_php_conversion_cost_kg] ) - [Plastic Savings / kg] ) )

Re: not the same total while averaging

Easley08 — Fri, 29 Dec 2023 07:49:34 GMT

thanks it works i used this measure also but without the calculate thats why im getting the wrong total.

Re: not the same total while averaging

Fowmy — Fri, 29 Dec 2023 08:24:48 GMT

Easley08

Yes, you need the CALCUALTE here to do the context-transition.