Gantt chart using matrix showing incorrect grand total and not regrouping raws

[Antonio91]

Hi everybody,

I'm not an expert in Power BI. I tried to create a Gantt chart using a matrix, following one of the many tutorials on the web. In this specific case I've got some car license plates (column "Targa") and some periods of time in which each car was not usable because it was under repair, delimited by a start date ("Data Apertura") and an end date ("Data Chiusura"). The result is ok, but I've got 2 more objectives I'd like to reach:

1) I'd like to read the grand total both in last raw and in last column, in order to count how many days each car wasn't usable (last column) and how many cars weren't usable each day (last raw). As for now, numbers shown in the grand total raw and column are incorrect;

2) most of the time, cars have got more than one period of unusability, so I'd like to regroup all periods in their respective car license plate raw (periods relative to the same car never overlap). I thought using the drill-up button would have made the job, but it didn't work (if I press drill-up, the car license plate raw just shows a series of zeros).

Here's a screenshot of the matrix. Please, can anybody help me?

Here are the links to the .pbix and the .xlsx files:

https://1drv.ms/f/s!AmB1iIhLzXlGgfYyBdHrMCNHxovXww?e=bGpWIY

Any suggestion is appreciated

Thanks a lot in advance

[v-shex-msft · Accepted solution]

Hi @Antonio91,

For the different hierarchy aggregation levels, they may not able to use simple formula to aggregate on different levels.
I'd like to suggest you add a variable table with summarize function to apply first level aggregate on records based on different category fields. Then you can use iterator function to apply the second level aggregations to these records.

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng