Forum Discussion

yve214's avatar
yve214
Icon for Helper III rankHelper III
4 years ago
Solved

Sumx function isn't working

Hi there,   please help me.   my sumx function isnt working for a total qty measure i calculated.   I have my Qty measure where I am replacing my empty rows with the previous values as such   ...
Sumx()
Total Measure
Urgent Help
Urgent Help with DAX
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi yve214 ,

    According to your description, please try this code:

    Iterative Qty =
IF (
    HASONEVALUE ( date[date_dt] ),
    [final Qty],
    SUMX ( VALUES ( date[date_dt] ), [final Qty] )
)

    Additionally, please see if this blog helps: Learn How to Fix Totals and Subtotals in DAX

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi yve214 ,

According to your description, please try this code:

Iterative Qty =
IF (
    HASONEVALUE ( date[date_dt] ),
    [final Qty],
    SUMX ( VALUES ( date[date_dt] ), [final Qty] )
)

Additionally, please see if this blog helps: Learn How to Fix Totals and Subtotals in DAX

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.