Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
3 years ago

Incorrect total with dax measure

Hi all   I need to get the sum product of a column multiplied by a percentage.    My dax measure called Demand by bottler (Year +2) should calculate the demand by location multiplied by the growt...
Need Help
Show and Tell
mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Hi o59393 

 

I don't know how are your measures defined, but what I have done is this:

 

 

Demand by bottler (Year +2) = 

SUMX ( 
   VALUES ( MyTable[Demand by bottler]),
    MyTable[Demand by bottler]+ (MyTable[Demand by bottler]* SUM(MyTable[Max of Year +1 (Growth %)]))
)