Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dax

Hi I want to write a code in order to sum the value of demand if the facility name is same for a particular date.

 

Is this possible? Please let me know 

Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    How about using "ALLEXCEPT('Table'[facility])" or "Filter(ALLSELECTED('Table'),'Table'[facility]=MAX('Table'[facility]))" in your Measure expression as a filter?

     

    If this doesn't work, please share us some sample data.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    Can you paste some sample data and then detail your requirement?

     

    Thanks,

    Pragati

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    How about using "ALLEXCEPT('Table'[facility])" or "Filter(ALLSELECTED('Table'),'Table'[facility]=MAX('Table'[facility]))" in your Measure expression as a filter?

     

    If this doesn't work, please share us some sample data.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.