Unable to calculate sum of average values

[Prabhu11]

Hi Community,

I am trying to find a sum of calculated average values, but couldn't achieve the expected result.

My model consists of 2 columns Production & Days, Rate is measure calculated by following formulae

Rate = Production / Days

My challenge is achieving subtotal for Rate

In the subtotal of Rate, I need to show the Sum of Rates (11658.56 Highlighted in table) instead of Avg (2814.48 Current output), 

Expected Table

factory	Production	Days	Rate
Region A	31445.37	11	2858.67
Region B	0	0	0
Region C	56848	13	4372.923077
Region D	83967.15	29	2895.418966
Region E	0	0	0
Region F	27567.9	18	1531.55
Region G	0	0	0
Subtotal	199828.4	71	11658.56204

Kindly help

Regards

Prabhu

[v-yadongf-msft]

Hi @Prabhu11 ,

Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Yadong Fang

[Shreeram04]

Hi @Prabhu11 ,

Please find the below screenshot and measure for your reference.

Add a column in the table which has data.

Measure 12 = SUM('Table (7)'[Production])

Measure 11 = SUM('Table (7)'[Days])

Column = DIVIDE([Measure 12],[Measure 11])

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

Thanks,

[Prabhu11]

Dear Shreeram,

Thanks for the response, I couldn't achieve the expected result because my Days column will be always One,

I'm counting all by using the SUM function.

Attached is the PBIX file for your reference kindly check

Link to download PBIX file 

Regards 

Prabhu

[Shreeram04 · Accepted solution]

Hi @Prabhu11 

I tried to count work_stats based on factory so that it takes the date count for each factory. By using that i divide that value to production value.

Please find the below measure and screenshot for your reference.

ss = CALCULATE(COUNTROWS(Sheet1),FILTER(Sheet1,Sheet1[factory]=EARLIER(Sheet1[factory])))

Column = DIVIDE([Production value],Sheet1[ss])

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

thanks,