Avg Price increase %age is not same as sum of sales current year/Sum of sales of previous year

[Djreddy]

Hi . below is the summary of tables, while am trying to find the value in Power BI, avg shown as 1.3 when it is calculated by value  of CY &PY is 1.25. and there is difference which am unable to get in any of the visual . Please suggest the way to do the same.

	Value Prev Year	Value Current Year	%age of increase
Raw Material X	5194000.00	5700000.00	1.09742
Raw Material X	2690750.00	2501010.00	0.929484
Raw Material X	2800000.00	5248000.00	1.874286
Sum	10684750.00	13449010.00	3.90119
Avg		1.25871078	1.300397	Avg of %age inc

[v-shex-msft]

Hi @Djreddy,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Djreddy]

Dear Sheng,

As mentioned in my first mail, if you select any Raw material and try to find Avg  of following ( CY(EYF22)/PY(EYF22)) the value of this calculation is not same as  Avg of PI EYF 22(EYF22). below is raw data for your reference

AI1	Product Type1	Sourcer	category1	PY(EYF 22)	CY(EYF 22)	PI EYF22(EYF 22)
Raw Material-1	RM/Intermediate	Sourcer-1	Herbicide	4,560,000	3,450,000	0.76
Raw Material-1	RM/Intermediate	Sourcer-1	Herbicide	2,080,040	1,783,925	0.86
Raw Material-2	RM/Intermediate	Sourcer-4	Insecticide	5,194,000	5,700,000	1.1
Raw Material-2	RM/Intermediate	Sourcer-4	Insecticide	2,690,750	2,501,010	0.93
Raw Material-3	RM/Intermediate	Sourcer-4	Insecticide	2,800,000	5,248,000	1.87
Raw Material-4	RM/Intermediate	sourcer-6	Insecticide	837,000	792,000	0.95
Raw Material-4	RM/Intermediate	sourcer-6	Insecticide	6,092,000	6,460,800	1.06
RM-14	RM/Intermediate	Sourcer-2	Fungicide	336,140	357,442	1.06
Raw Material-6	RM/Intermediate	sourcer-6	Herbicide	5,000,000	2,864,890	0.57
Raw Material-6	RM/Intermediate	Sourcer-2	Herbicide	2,204,400	2,354,700	1.07
RM-7	RM/Intermediate	Sourcer-3	Fungicide	3,894,583	6,586,788	1.69
RM-8	RM/Intermediate	Sourcer-4	Insecticide	2,784,376	2,784,376	1
RM-9	RM/Intermediate	Sourcer-4	Insecticide	1,428,395	1,974,368	1.38
RM-10	RM/Intermediate	Sourcer-1	Herbicide	43,075,982	########	1.11
RM-11	RM/Intermediate	Sourcer-2	Herbicide	298,734	309,478	1.04
RM-12	RM/Intermediate	Sourcer-3	Fungicide	2,856,532	2,777,888	0.97

[v-shex-msft]

Hi @Djreddy,

It seems like a common measure total level calculations issue when it handles with multiple aggregations, you can refer to the Greg’s blog to know how to solve this issue:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[amitchandak]

@Djreddy , You need a approach like this

https://amitchandak.medium.com/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be

https://youtu.be/OSwRZ4GUhxc

P&L with Custom sub total- https://youtu.be/C9K8uVfthUU