How to sum average data

[prapatsornchar]

Hello,
as you can see, the total sum is wrong

i want to sum of my average data

here is the file : https://drive.google.com/file/d/1JErU8xK8xG49hoN2t0tX2MgI5DPZF3N1/view?usp=sharing

Please help,

thank you 

Ps: sorry for my language

[prapatsornchar]

Thank you so much, i really appreciate for you help

[Fowmy]

@prapatsornchar 

You are just averaging the Invetory column so at the total level, it returns the average of the complete table. 
What sort result do you want to calculate for the total row?

[prapatsornchar]

yes, i use average formula for inventory column

but i want sum it

 
from the picture, i want total number to be 21,076.4

(1882+274+1689+337+500+456+118+983.4+381+1265+1101+12090=21076.4)

[Fowmy]

@prapatsornchar 

You file cannot be accessed

[prapatsornchar]

can you try again?

i already set share option on my google drive

[Fowmy · Accepted solution]

@prapatsornchar 

You can create a measure as follows:

Avg Inventory = 
IF(
   ISINSCOPE( Sheet1[Sec]),
   AVERAGE( Sheet1[inventory] ), 
   SUMX(
        VALUES( Sheet1[Sec] )  , CALCULATE( AVERAGE( Sheet1[inventory]))
   ) 
)