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

1 Reply

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