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]
    )
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