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 help. Cheers

 

SUMX(FILTER(VALUES(SHIPPING[DISCHARGE_COMMENCE],SHIPPING[SHIPMENT_NO]),[DATEDIFF]>=0),[TA_WEIGHTOMETER])
Need Help

5 Replies

  • niteshtrehan89's avatar
    niteshtrehan89
    Helper III
    5 years ago

    function=

    var x= VALUES(SHIPPING[DISCHARGE_COMMENCE]

    var y= VALUES(SHIPPING[SHIPMENT_NO])

    return

    SUMX(FILTER(x,y,[DATEDIFF]>=0),[TA_WEIGHTOMETER])

    • kumsha1's avatar
      kumsha1
      Post Patron
      5 years ago

      Hi niteshtrehan89 , thanks for your quick response.

       

      I tried creating variables as mentioned but the DATEDIFF is not being accepted with error 'unexpected parameter'.

       

       

  • 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.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi kumsha1 ,

     

    I don't quite understand the formula. Can you show more details?

     

    Best Regards,

    Jay