Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Please help replace this QV code into DAX.
sum(TOTAL <Recipe_COMPONENT>
AGGR(
sum([Q-TY])
/ 1000
*
(
(sum([Despatch Volume Cases]) + sum([Promo Cases]))
/
(sum([Despatch Volume Tonnes]) + sum([Promo tonnes]))
)
*
(sum([Despatch Volume Tonnes]) + sum([Promo tonnes]))
, Recipe_COMPONENT
, RECIPE
)
)
can you explain the QV code step by step so I can convert it to dax
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
The problem is I can explain AGGR function for myself 🙂 I thought that someone have expirience
as in PBI as in QV .
What is the logic behind this , and would you please paste your scenario here
Thank you
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
This is a part of big formula for one evaluation inside visual. All data in this formula stored in one table.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 103 | |
| 80 | |
| 62 | |
| 50 | |
| 45 |