Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
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
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |