Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
This is how the model looks like (the relevant tables from it):
The Timesheet table contains the hours the workers worked with each Task.
The image below show my problem:
The "Planned days" column is in the "Task" table, the "Hours" is the SUM of the hours in the "Timesheet" table. My problem is that if I include the Workers in the report, the "Planned days" column becomes blank when there is no hours wrote on the task, but if I remove it, it works fine.
My 2 questions are:
1. Can someone explain this behaviour to me?
2. What Measure should I write to overcome this behaviour? (Currently I just dropped the "Task" table's "Planned days" column.
Hi @Arklur,
In your report, there are in same level?
For your scenario, please create a measure to get Planned days using the formula and check if it works fine.
Planned days=CALCULATE(SUM(Table[Planned days]),ALL(Table))
Best Regards,
Angelia
> In your report, there are in same level?
No, but it was intentional to show what's the problem.
As for your Measure, it's not working because it simply calculates the total "Planned days" for all the tasks, the Order isn't taken into account (it's not "Grouped By" the Order). Also, if I drill down to the "Worker Level", it...does weird things:
Hi @Arklur,
Do you mins share your .pbix file for further analysis?
Best Regards,
Angelia
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |