Forum Discussion
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...
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.
mlozano
Helper III
Helper IIITry this:
Total Capacity = CALCULATE(
SUM(Tabla[límite de trabajo]), ALL(Tabla[Empleado]))
This did not work for me. The results are the same as the job cap.
- ddpl
Solution Sage
this 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]))
