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 tha...
  • 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]
    )
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.