Gantt sub-tasks issues with matrix

[cdeletre]

Hello !

I'm trying to make a gantt chart using a matrix for a project.

The principle is that a project is defined by a start date and an end date, I define a table that includes the 12 months of the year, and for each month I calculate if the project slot is during that month, if so I put the value of the column "type" otherwise I put 0. And the display is done according to the conditional formatting.

IsProjet =

VAR CurrentMonth = SELECTEDVALUE('Month'[EndOfMonthDate])

RETURN

IF(

CurrentMonth >= EOMONTH(MAX(data[DateStart]), 0) && CurrentMonth <= EOMONTH(MAX(data[DateEnd]),0),

MAX(data[Type])

,

0

)

On the principle it is not so bad, however I do not manage to have this distinction if a project with two stages, on the following example we can see that the sub-tasks are done correctly but the sum by "column" does not correspond... in short the problem comes from the sums of the sub-columns but impossible to make it work, if somebody has an idea...

I've seen quite a few posts on the forum related to matrix totals and subtotals but I haven't managed to find the solution.

Thanks in advance!

The link of the simplified project: https://drive.google.com/file/d/1R3ve_IHF_RH4EZHrkqN3h9vurlyoaSwv/view?usp=share_link

[cdeletre]

up