Remove Date filter

[Anonymous]

Hi 

I'm trying to amend the following to remove the filter for Job_Ledger_Entries[Month End] the variable DefInc

#DeferredIncome =
VAR _To =
    (
        CALCULATE (
            MAX ( Job_Ledger_Entries[Month End] ),
            ALLSELECTED ( Job_Ledger_Entries[Month End] )
        )
    )
VAR _From =
    CALCULATE (
        MIN ( Job_Ledger_Entries[Month End] ),
        ALLSELECTED ( Job_Ledger_Entries[Month End] )
    )
VAR Cust =
    SELECTEDVALUE ( Job_Card[Bill_to_Name] )
VAR DefInc =
    CALCULATE (
        SUM ( General_Ledger_Entries[Debit_Amount] ),
        FILTER (
            General_Ledger_Entries,
            General_Ledger_Entries[G_L_Account_No] = "20130"
                && General_Ledger_Entries[Posting_Date] >= _From
                && General_Ledger_Entries[Posting_Date] <= _To       
        )
    )
RETURN
    DefInc

I thought I could use REMOVEFILTERS but I can't get it to work. Appreciate any advice 

Thanks

[Anonymous]

Thanks for the reply. That worked for me

[tamerj1 · Accepted solution]

Hi @Anonymous 

If REMOVEFILTERS didn't work you can try to wrap the first CALCULATE  with another one that has the REMOVEFILTERS