Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
jay_patel
Helper IV
Helper IV

Need exact sum of volume at country level

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 

CountryBrandProduct Group NameYR 3 REV-QtyYR 4 REV-QtyYear 3 ACT Net SalesVolume final
NigeriaIbucapIbucap Caps 10C (BamBam)26521755-9.860722673
NigeriaIbucapIbucap Caps 10C (Monopack)34617876-37.0216
NigeriaIbucapIbucap Caps 25x10C261018.1104
NigeriaIbucapIbucap Cold & Flu Syrp 100ml132465.531746695
NigeriaIbucapIbucap Cold & Flu Tabs 4T10610113-0.57012667
NigeriaIbucapIbucap Forte Caps 10C1364938-24.24678662




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

CountryYR 3 REV-QtyYR 4 REV-QtyVolume finalYear 3 PU finalVol.Growth %
Nigeria868576-16745.724000003-846%



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

Thanks in advance

1 REPLY 1
v-xuxinyi-msft
Community Support
Community Support

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.