Filter in CALCULATE

[rmcgrath]

I'm working with Accounts Receivable data and I have two DAX measures.  One controls the [Amount Due] to grab everything greater than $500.  The other one calculates the AR total less anything considered "Current".  How can I apply AmountDuewithAllDelinquency > 500 to the second?

AmountDuewithAllDelinquency =

CALCULATE (

    SUM ( 'Accounts Receivable'[Amount Due] ),

    ALL ( 'Accounts Receivable'[Delinquency] )

)

 

ARtotal =

CALCULATE (

    SUM ( 'Accounts Receivable'[Amount Due] ),

    Customer[EGG/NON-EGG] = "EGG",

    Delinquency[Delinquency] <> "Current",

    Customer[INTERNAL/EXTERNAL] = "EXTERNAL"

)

[bhanu_gautam · Accepted solution]

@rmcgrath , Try using

DAX
ARtotal =
CALCULATE (
SUM ( 'Accounts Receivable'[Amount Due] ),
Customer[EGG/NON-EGG] = "EGG",
Delinquency[Delinquency] <> "Current",
Customer[INTERNAL/EXTERNAL] = "EXTERNAL",
FILTER (
'Accounts Receivable',
[AmountDuewithAllDelinquency] > 500
)
)