Weekly sum of daily averages

[Anonymous]

Hello,

I read many posts about that subject and out of them I couldn't find a solution that works for me.

My need is the following.

In the table below I need to have the average GT2 per subtask or task for the data to be correct on these lines.

And in the different aggregation level (date, week, month) I need to have a sum of the average GT2 per subtask, task.

And I don't find how to do that.

Additionnal info:

GT2 = GT3 = theoretical day shift duration

When I used average instead of sum with GT3 data the task, subtask and date values are correct but then the week and month are not.

example of expected result:

For the 11th of january:

	Somme de Temps passé	Somme de GT2
Jeudi 11 janvier 2024	9,5	8,00
AB	5,00	8,00
DED	2,00	8,00
DEL	3,00	8,00
HO	2,00	8,00
PR	2,50	8,00

But for the entire week I need to see:

	Somme de Temps passé	Somme de GT2
Week 2	22,50	22,50

Data sample:

N° Mois	N° Semaine	Date	Task	SubTask	Temps Passé	GT2 (=GT3)
1	2	10/01/2024 00:00	HR		1	8
1	2	10/01/2024 00:00	PR		7	8
1	2	11/01/2024 00:00	AB	DED	2	8
1	2	11/01/2024 00:00	AB	DEL	3	8
1	2	11/01/2024 00:00	HO		2	8
1	2	11/01/2024 00:00	PR		2,5	8
1	2	12/01/2024 00:00	HO		0,17	6,5
1	2	12/01/2024 00:00	PR		4,83	6,5

Thanks for your help,

Toftaf.

[Anonymous]

hello @amitchandak ,

Thanks for your answer.

I tried your solution without success. I also tried to investigate further by watching the video you suggested however it did not work either.

I'm still stuck with the sum of averages not working. I'm guessing that I probably have to extract the averages at a certain level into another table to be able to sum them up from that new table. I didn't had a chance to try yet.

I'll let you know if that works.

Thanks for your help.

[amitchandak]

@Anonymous , Assume you have measure M1 which does Avg, And after Level 2 we want SUm

Sumx(Values(Table[Level 2]), [M1])

For more complex ones you can use isinscope to control what you show at each level

IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM