Measure shows value in table, will not sum elsewhere? __ Updating with details

[Bodhi314]

Fairly new user (6 months focused) - so please help me learn - thank you!

I created a measure that sums up the parts in a BOM and filters the values by two pieces, source of parts and billing dept.

The correct values display in a table by order number, but am unable to utilize the value for a summation by billing dept.

Can someone help me get the table output in usable form for calculations?

The measure shows values correctly in table - all three tables are connected:

CUSTOM =

VAR Qty_Price_dollar =

        CALCULATE(

            SUM(Parts[Parts_LastOriginatingCost])* SELECTEDVALUE( BOM[Parts_Qty])

        )

RETURN

CALCULATE(

   Qty_Price_dollar,

    FILTER(OrderDetails,OrderDetails[OrDetails_BuildShop_Code] = "XX"),

    FILTER( Parts, Parts[Parts_Flag_Floorstock_Custom])

    )

[HotChilli · Accepted solution]

One of the problems with the measure is that once the variable is evaluated, it is a fixed value.  The part in the return clause will not do anything.

--

Also, If you want help from the community, you should read the 'How to get your question answered' post.  This question is lacking a lot of detail (sample data, desired result, relationships.......)

[Bodhi314]

Thank you - my first time here - I'll read as you suggest and update.