Forum Discussion

lbraeckman's avatar
lbraeckman
Frequent Visitor
5 years ago
Solved

DAX - SUMX does not return expected result

Hi All, We need to calculate the average number of weeks that are passed before 80% of the sales are reached. So first we need a calculation to get this measure per product (KMM_Name), then we need ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  lbraeckman ,

     

    Try the measure below:

     sumx(values(Movies[KMM_Name]), [OLD - Avg Week GBO > 80%])


    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

lbraeckman's avatar
lbraeckman
Frequent Visitor
5 years ago

Thanks for the suggestion, but this gives me 0 as result

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  lbraeckman ,

 

Try the measure below:

 sumx(values(Movies[KMM_Name]), [OLD - Avg Week GBO > 80%])


Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

  • lbraeckman's avatar
    lbraeckman
    Frequent Visitor
    5 years ago

    Super, this solves it, thank you!