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.
ddpl
Solution Sage
Solution SageHi Try this one
Column =
CALCULATE ( SUM ( 'Table'[Job Cap] ), DISTINCT ( 'Table'[Employee] ) )
CALCULATE ( SUM ( 'Table'[Job Cap] ), DISTINCT ( 'Table'[Employee] ) )
==Mark solution as accepted if its worked
The result is the same as job cap and not the total.