Forum Discussion
Replace QlickView AGGR function
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
)
)4 Replies
What is the logic behind this , and would you please paste your scenario here
Thank youThis is a part of big formula for one evaluation inside visual. All data in this formula stored in one table.
can you explain the QV code step by step so I can convert it to dax
The problem is I can explain AGGR function for myself 🙂 I thought that someone have expirience
as in PBI as in QV .
