Forum Discussion
Sum Total based on Columns
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.
This did not work for me. The results are the same as the job cap.
Solution Sagethis is result you want right??
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-msftCommunity Support
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.This actually works! Thank you.