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.
This didnt work for me. Getting an error EARLIER/EARLIEST refres to an earlier row context which doesnt exist.
FYI - The rows might not necessarily be sequential by employees. They are not in specific orders if that helps.
Ashish_Mathur
Super User
Super UserShare the link from where i can download your PBI file.