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

[mformagnificent]

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.

[Anonymous]

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

[bhanu_gautam · Accepted solution]

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

@mformagnificent , Try using below measure

Runout = SUMX(

    RunOutTable,

    RunOutTable[Inventory] - CALCULATE([Daily Usage], RunOutTable)

)

[mformagnificent]

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.