Forum Discussion

rmcgrath's avatar
rmcgrath
Advocate III
1 year ago
Solved

Filter in CALCULATE

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 consi...
Need Help
Show and Tell
Tips and Tricks
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    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
    )
    )

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

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
)
)