Forum Discussion

RatanaPOUY's avatar
RatanaPOUY
Frequent Visitor
6 years ago
Solved

Sum distinct base on column

hi,   i have a detail table as follow: Table name: Daily Transaction then create a new table to distinct delivery number Delivery Order = DISTINCT('Daily Transaction'[Delivery]) ...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi RatanaPOUY ,

     

    You may create measure like DAX below.

     

    Sum Volume= CALCULATE(SUM('Daily Transaction'[Volume]),FILTER(ALLSELECTED('Daily Transaction'), 'Daily Transaction'[Delivery] =MAX('Daily Transaction'[Delivery])))

     

    Or you can just change the show aggregation of Volume to Sum.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

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

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi RatanaPOUY ,

 

You may create measure like DAX below.

 

Sum Volume= CALCULATE(SUM('Daily Transaction'[Volume]),FILTER(ALLSELECTED('Daily Transaction'), 'Daily Transaction'[Delivery] =MAX('Daily Transaction'[Delivery])))

 

Or you can just change the show aggregation of Volume to Sum.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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