Total Sum by Column (Matrix)

[Belle2022]

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 display the value in the table. 

This is my current Gantt Chart.

This is the output that I intended to do.

This is the formula that I used to get the value in the matrix :

column values =

VAR _startdate =

CALCULATE(

min('Task Tracker'[start date]),

all('Date'[Date])

)

var _enddate =

calculate(

max('Task Tracker'[expected end date]),all('Date'[Date])

)

var _status =

CALCULATE(max('Task Tracker'[current status]),all('Date'[Date]))

var _period =

min('Date'[Date]) >= _startdate && max('Date'[Date])<=_enddate

return

switch(

true(),

_period && _status = "Completed",1,

_period && _status = "In progress",2,

_period && _status = "Overdue",3,

_period && _status = "On Hold",4,

_period && _status = "Yet to start",5)

[amitchandak]

@Belle2022 , Not very clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Also, refer my attempt to use Matrix as visual as project plan

Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

[Belle2022]

Sure, attached link here is the sample pbi & the expected output. Lemme know if you have the solution. Thanks!

Sample PBI & Expected Output 

[V-lianl-msft · Accepted solution]

Hi ,

Please refer to the sample pbix:

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.