Multiple filters on a calculate sum formula

[Anonymous]

I have a column that I created that basically acts as a sumifs and seems to work for the most part except i need to add one more filter onto the code. 

Below is the code.

Expense Budget = CALCULATE(SUM(Budgets[Amount]),FILTER(ALL(Budgets),[Acct_no]=EARLIER(Budgets[Acct_no])))

The additional filter would be for the departments so something like [Dept_no]=EARLIER(Budgets[Dept_no]. I havent been able to figure out where in this current formula that could fit into without an error

[dedelman_clng · Accepted solution]

You should be able to do it in one of three ways:

2nd filter argument for CALCULATE

Expense Budget =
CALCULATE (
    SUM ( Budgets[Amount] ),
    FILTER ( ALL ( Budgets ), [Acct_no] = EARLIER ( Budgets[Acct_no] ) ),
    [Dept_no] = EARLIER( Budgets[Dept_no] )
)

2nd filter argument for CALCULATE with an explicit FILTER call

Expense Budget =
CALCULATE (
    SUM ( Budgets[Amount] ),
    FILTER ( ALL ( Budgets ), [Acct_no] = EARLIER ( Budgets[Acct_no] ) ),
    FILTER ( ALL ( Budgets ), [Dept_no] = EARLIER ( Budgets[Dept_no]) )
)

2nd argument inside original FILTER call using && 

Expense Budget =
CALCULATE (
    SUM ( Budgets[Amount] ),
    FILTER ( ALL ( Budgets ), [Acct_no] = EARLIER ( Budgets[Acct_no] ) &&
                                 [Dept_no] = EARLIER ( Budgets[Dept_no] ) )
)

If none of these work, please provide sample data and the error messages you are getting.

Hope this helps

David