Dynamically calculating cost based on user input quantity

Hi Rajesh1

Try this

You can pull the Applicable Variable Charge from "Cost Matrix" to your "Input Table" using this MEASURE

Applicable Variable Charge =
CALCULATE (
    VALUES ( CostMatrix[Variable Charges per unit] ),
    FILTER (
        CostMatrix,
        CostMatrix[Product] = SELECTEDVALUE ( 'InputTable'[Product] )
            && CostMatrix[Zone] = SELECTEDVALUE ( 'InputTable'[Zone] )
            && SELECTEDVALUE ( 'InputTable'[Input Qty] ) >= CostMatrix[Quantity From]
            && SELECTEDVALUE ( 'InputTable'[Input Qty] ) <= CostMatrix[Quantity To]
    )
)

Thanks very much for your timely assistance, Zubair_Muhammad!

Works like a charm!  thank you.. thank you.. thank you