Read correct price from table with minimum quantities

Hi Schorse ,

Have your problem solved?

If yes, please make that post helpful to you, as a solution. So that others have the same problems as you can find the answer quickly.

If no, maybe you can try this measure.

Measure =
VAR _minq =
    CALCULATE(
        MIN( 'Table'[MinQuantity] ),
        ALLEXCEPT(
            'Table',
            'Table'[ItemNo.]
        )
    )
RETURN
    CALCULATE(
        MIN( 'Table'[Price] ),
        FILTER(
            ALLEXCEPT(
                'Table',
                'Table'[ItemNo.]
            ),
            [MinQuantity] = _minq
        )
    )

Result:

If i misunderstood you ,please share you pbix file without sensitive data and expect result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.