Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
Forced to ask for help from the community, because I can not solve the problem.
I have such a data model (my test.pbix is here😞
Here worklog(2) is a table in which all activities are logged, such as vacation (time_spent_vacation) and all other work time (time_spent).
msrs table - table for hold the measures
I need to show a table where the employee will be displayed, each calendar day of the month, which activities were performed (time_spent_vacation / time_spent), if any.
Also, it is necessary to consider the planned working hours on those days of the calendar month that are not weekends and not holidays (this is a Capacity measure).
The question is, how do I calculate the NotReported measure?
In my opinion, this is the sum of all the "positive" values in case [Capacity] - [time_spent] in the table below and it should be in the "total" value 123, not 3:
HI @Vitaliy ,
You can take a look at following blog to know how to handle measure total level calculation issue:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |