How to filter data based om another filed in the database

[Gschie]

Hello

I am new in this DAX language, so please help me.

I have at table it contains Amount and accountnumbers.

AcAm = Amount

AcNo = AcountNr

I want to sum(AcAM where AcNo >3000 and AcAm < 4000)

What is the syntax??

Gunnar Schie 

[greggyb · Accepted solution]

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.

[Gschie]

Thank you for quick response!

I'm not shure aboat the hard-code 😉

But this measure, i write this in table view. I connect my table in SQL database (Tabel AcTr)

I make a new messure: Amount

I make a new colomn: Filtered Amount.

Is this correct?

Gunnar Schie

[greggyb]

Both of those that I gave you should be defined as measures. Measures can be used in any visualization.

[Gschie]

Yesss! it worked, Thank you 🙂

/Gunnar