Forum Discussion

kumsha1's avatar
kumsha1
Post Patron
5 years ago

Multiple column references for FILTER

Hi, VALUES can accept single column reference in FILTER... So, how can i rewrite below DAX to pass multiple column references for FILTER?, to pass another column as highlighted in RED. TIA for your ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

kumsha1 , Not very clear what you want from the formula.

Try like SUMX(FILTER(Summarize(SHIPPING[DISCHARGE_COMMENCE],SHIPPING[SHIPMENT_NO],"_1",[DATEDIFF],"_2",[TA_WEIGHTOMETER]),[_1]>0),[_2])

  • kumsha1's avatar
    kumsha1
    Post Patron
    5 years ago

    amitchandak , i have below error

    Requirement is to filter the values by multiple columns to get the correct aggregation.