Forum Discussion
Total Sum by Column (Matrix)
Created a gantt chart using matrix. I want to display the row total count with value for each date. Below is the image on the table i've been working out, together with the formula that I used to dis...
Hi, Anonymous
Try to create a measure like this:
_Measure = SUMX('sample data',[column values])Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Im expecting the totals for each columns in which the cells have value - doesnt matter the value 1,2,3,4, or 5, it will count as 1. Lemme know if you have the solution thnks!
Or we can change the values as 1 and get the total for each columns
_period && _status = "Completed",1,
_period && _status = "In progress",1,
_period && _status = "Overdue",1,
_period && _status = "On Hold",1,
_period && _status = "Yet to start",1)
that can be rewritten as
_period && _status IN { "Completed","In progress", "Overdue","On Hold","Yet to start"},1okay but is there any ways that we can get the totals at the bottom for each date consisting 1? as my current formula only display 1 as total in the matrix
