Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
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.
@Toftaf , 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
95 | |
86 | |
76 | |
64 |
User | Count |
---|---|
138 | |
113 | |
109 | |
98 | |
93 |