Calculate average of sum of production for each code

[Anonymous]

Hi,
I am having a date filter with values year, month and day. I am having a table with two columns - one with code (it has duplicates) and corresponding productions for the day selected. I tried the following measure but its wrong. 

CALCULATE(SUMX(VALUES('WASTAGE'[CODE]), AVERAGE('WASTAGE'[PRODUCTION])))

Can anyone help ?

[qqqqqwwwweeerrr]

Hi @Anonymous 

Can you provide more details about the data and expected output? Sample data. The problem statement is not very clear.

Regads

[Anonymous]

Hi @qqqqqwwwweeerrr , thanks for your response. 

Iam having a date filter. On selecting the date I want (4th-jan-2023 here) i want to calculate the total sum of averages of the production wrt to the code i.e ((800+800+.....+800)/7) + ((11776+ 11776+ .....11776)/5) => 800+11776 = 12567

I have tried the following measure , 

Total_production = SUMX(VALUES('WASTAGE'[CODE]), AVERAGE('WASTAGE'[PRODUCTION]))

and im getting 10,746 as the result for the above data which is wrong. Any help is appreciated.
Thanks.

[Anonymous · Accepted solution]

Hi , I found a working solution to the above problem. Im adding it here just for reference.

NTest = 
var x = SUMX(SUMMARIZE(WASTAGE,(WASTAGE[CODE]), "Summ", sum(WASTAGE[PRODUCTION])), [Summ])
var y = count(WASTAGE[PRODUCTION])
return
x/y

NTest1 = 
VAR a = VALUES( WASTAGE[CODE] )
VAR Result = SUMX(a,[NTest])
RETURN 
IF(HASONEFILTER(WASTAGE[CODE]), [NTest], Result)