How to filter data based om another filed in the database

First, does this need to be hard-coded into a measure, or can you get away with using filters in your report?

If this needs to be in a measure, it's a simple call to CALCULATE():

Amount =
SUM( 'MyTable'[AcAm] )

Filtered Amount =
CALCULATE(
    [Amount]
    ,'MyTable'[AcNo] > 3000
    ,'MyTable'[AcAm] < 4000
)

CALCULATE() allows you to define simple predicates to filter expressions, or complex table expressions to define the context for the expression. All arguments 2-N of CALCULATE() are evaluated in a logical and.