Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sum Total based on Columns

Hello All,   How can I achieve the outcome listed below for Total Capacity? I am using a matrix table and I want to add a column like Total Capacity below that shows the Job Cap total based on Empl...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

     

    In the image above,  can you share yours [Planner] column?Because this is a  [Planner] column grouping.

    Base on the example you offered. You could try this dax.

    Total capacity 2 = CALCULATE(SUM([Job Cap]),ALLEXCEPT('Table','Table'[Employee]))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

It is what i wanted but when i try to follow the same DAX it yields differently.

 

Total Capacity = CALCULATE(SUM(ProgressTable[Capacity Score]),DISTINCT(ProgressTable[Planner]))
 
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ;

 

In the image above,  can you share yours [Planner] column?Because this is a  [Planner] column grouping.

Base on the example you offered. You could try this dax.

Total capacity 2 = CALCULATE(SUM([Job Cap]),ALLEXCEPT('Table','Table'[Employee]))

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This actually works! Thank you.