Need exact sum of volume at country level

[jay_patel]

Hello Experts,

I have a dax for volume = (current year qty - last year qty)* Per Unit. which is working fine at SKU level for specific Country as mentioned below 

Country	Brand	Product Group Name	YR 3 REV-Qty	YR 4 REV-Qty	Year 3 ACT Net Sales	Volume final
Nigeria	Ibucap	Ibucap Caps 10C (BamBam)	265	217	55	-9.860722673
Nigeria	Ibucap	Ibucap Caps 10C (Monopack)	346	178	76	-37.0216
Nigeria	Ibucap	Ibucap Caps 25x10C	2	6	10	18.1104
Nigeria	Ibucap	Ibucap Cold & Flu Syrp 100ml	13	24	6	5.531746695
Nigeria	Ibucap	Ibucap Cold & Flu Tabs 4T	106	101	13	-0.57012667
Nigeria	Ibucap	Ibucap Forte Caps 10C	136	49	38	-24.24678662

But when i Drill up to Country Level i am getting too much difference in Volume final.

Country	YR 3 REV-Qty	YR 4 REV-Qty	Volume final	Year 3 PU final	Vol.Growth %
Nigeria	868	576	-1674	5.724000003	-846%

I am not at which level this is happening, i need -48 at Country level for brand Ibucap.

Thanks in advance

[v-xuxinyi-msft]

Hi @jay_patel 

Could you please provide me with some sample data and the result based on the sample data? That would be very helpful. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account. Thank you for your efforts in advance.

Best Regards,
Yulia Xu