Forum Discussion

mformagnificent's avatar
mformagnificent
Regular Visitor
2 years ago
Solved

Please help: SUMX function not working. Is there another function I should be using?

My SUMX formula is not working

 

I want the Runout measure to subtract the Inventory column and the daily usage column. How can I do that? I tried using SUMX function but it's giving me amounts that is not the correct subtraction result. 

 

Runout = SUMX(RunOutTable, RunOutTable[Inventory] - [Daily Usg])
 
Daily Usage = [QtyTotal]/([DateDuration] * (5/7)) - This is a measure not a column.

Column "Inventory" is TotalPhysicalInvent - Delivery Remainder.

 

 

 

  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    mformagnificent , You are getting this error because daily usage is measure , either convert in calculated column

     

    or use below

    Runout = SUMX(
        RunOutTable,
        RunOutTable[Inventory] - [Daily Usage]
    )

4 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    mformagnificent , Try using below measure

     

    Runout = SUMX(
        RunOutTable,
        RunOutTable[Inventory] - CALCULATE([Daily Usage], RunOutTable)
    )
    • mformagnificent's avatar
      mformagnificent
      Regular Visitor
      2 years ago

      Daily usage is a measure not a column. When I inserted your formula I get this message. Is there another method we can try? Also, thank you for responding. 

       

       

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    mformagnificent , You are getting this error because daily usage is measure , either convert in calculated column

     

    or use below

    Runout = SUMX(
        RunOutTable,
        RunOutTable[Inventory] - [Daily Usage]
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi mformagnificent ,

     

    Please try this measure:

    Runout = SUM ( RunOutTable[Inventory] ) - [Daily Usg]

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum