Forum Discussion

olivere91's avatar
olivere91
Icon for Helper I rankHelper I
5 years ago
Solved

Incorrect Measure Totals

Hi, I'm having trouble with a measure giving inconsistent results:   Available Inventory = SUM('items'[Inventory]) - SUM('Sales_Lines'[Quantity on SO])   Below is an exmaple, the top line is c...
  • themistoklis's avatar
    themistoklis
    5 years ago

    Try the following formula

    Available Inventory = SUMX(VALUES ( 'items'[Item_Number] ), CALCULATE ( SUM ('items'[Inventory])))
    -
    SUMX(VALUES ( 'items'[Item_Number] ), CALCULATE ( SUM ('Sales_Lines'[Quantity on SO])))

     

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
5 years ago

Try the following formula

Available Inventory = SUMX(VALUES ( 'items'[Item_Number] ), CALCULATE ( SUM ('items'[Inventory])))
-
SUMX(VALUES ( 'items'[Item_Number] ), CALCULATE ( SUM ('Sales_Lines'[Quantity on SO])))

 

olivere91's avatar
olivere91
Icon for Helper I rankHelper I
5 years ago

That didn't work. These are the column headers if that helps.

 

 

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    5 years ago

    olivere91 

     

    Change 'items'[Item_Number]  to No .. name of first field.

    If you could share the file that would be even better. Mask any sensitive data

    • olivere91's avatar
      olivere91
      Icon for Helper I rankHelper I
      5 years ago

      Yeah, I replaced the 'items'[Item_Number]  to No. Sorry I'm very new at this I don't know how to mask. 

      • olivere91's avatar
        olivere91
        Icon for Helper I rankHelper I
        5 years ago

        I fixed it! the measure now reads:

         

        Available Inventory = SUMX(VALUES ( 'items'[No] ), CALCULATE ( SUM ('items'[Inventory])))
        -
        SUMX(VALUES ( 'items'[No] ), CALCULATE ( SUM ('Sales_Lines'[On Open SO])))
         
         
        Can you explain why my original measure wasn't working every time?