Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Remove Date filter

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

 
  • Hi Anonymous 

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

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi Anonymous 

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for the reply. That worked for me