topic Re: How to sum average data in Custom Visuals Development Discussion

How to sum average data

prapatsornchar — Sat, 28 May 2022 17:56:07 GMT

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

Re: How to sum average data

Fowmy — Sat, 28 May 2022 18:51:27 GMT

@prapatsornchar

You file cannot be accessed

Re: How to sum average data

prapatsornchar — Sat, 28 May 2022 19:14:22 GMT

can you try again?

i already set share option on my google drive

Re: How to sum average data

Fowmy — Sat, 28 May 2022 19:50:13 GMT

@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?

Re: How to sum average data

prapatsornchar — Sat, 28 May 2022 19:59:46 GMT

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)

Re: How to sum average data

Fowmy — Sat, 28 May 2022 20:16:18 GMT

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

Re: How to sum average data

prapatsornchar — Thu, 02 Jun 2022 15:04:45 GMT

Thank you so much, i really appreciate for you help