Remove Date filter

Anonymous — Thu, 10 Mar 2022 17:23:17 GMT

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

Re: Remove Date filter

tamerj1 — Thu, 10 Mar 2022 17:33:30 GMT

Hi Anonymous

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

Re: Remove Date filter

Anonymous — Fri, 11 Mar 2022 14:52:16 GMT

Thanks for the reply. That worked for me

topic Remove Date filter in DAX Commands and Tips

Remove Date filter

Re: Remove Date filter

Re: Remove Date filter