Forum Discussion

PshemekFLK's avatar
PshemekFLK
Icon for Helper IV rankHelper IV
5 years ago

SUMX weighted average doesn't work

Hi,   I can't figure out why sumx doesn't result in the correct weighted average:   Formula for Funnel Speed (Months) =  IF( HASONEVALUE('Funnel Data'[Opportunity Closed Mo No]),      S...
DAX
sumx
weighted average
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

PshemekFLK , try a measure like

 


Formula for Funnel Speed (Months) =
IF( Sumx(values('Funnel Data'[Opportunity Closed Mo No]),calculate(
SUM('Funnel Data'[Funnel Speed])/30,
DIVIDE(SUMX('Funnel Data','Funnel Data'[Funnel Speed]/30*'Funnel Data'[Opportunities Won Value USD]),
SUM('Funnel Data'[Opportunities Won Value USD]))))

  • PshemekFLK's avatar
    PshemekFLK
    Icon for Helper IV rankHelper IV
    5 years ago

    amitchandak 

    When I try to fix the brackets in this formula I still get 1.2 as Total not 2.7.

     

    I see you've changed the first part of the formula. I thought it's the second DIVIDE part that produces a wrong result.

     

     

    • PshemekFLK's avatar
      PshemekFLK
      Icon for Helper IV rankHelper IV
      5 years ago

      Can anyone give it a try? I still can't get to the right result