Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I am currently working on a report which looks at timesheets of engineers. I have calculated the Cumulative CAPEX and Total hours by using the following DAX:
What is the best way to ensure that there are distinct Cumulative Target hours for the engineers?
I look forward to hearing from you guys!
Cheers 🙂
Hi @Anonymous ,
Has your question solved? If solved ,you could share your solution then mark it .If not ,could you pls share your pbix file ? Remember to remove confident data.
Best Regards
Luicien
@Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Try like
Cumulative Target Hours =
VAR NoEmp =
DISTINCTCOUNT( TeamsandRoles[Developer Name] )
VAR Target =
CALCULATE (
[Target Hours Per Day],
FILTER (
ALLSELECTED ( 'Calendar'[Date].[Date] ),
'Calendar'[Date].[Date] <= MAX ( 'Calendar'[Date].[Date] )
), filter(allselected(TeamsandRoles[Developer Name] ), TeamsandRoles[Developer Name] =max(TeamsandRoles[Developer Name] ))
)
RETURN
NoEmp * Target
or
Cumulative Target Hours =
VAR NoEmp =
DISTINCTCOUNT( TeamsandRoles[Developer Name] )
VAR Target =
CALCULATE (
[Target Hours Per Day],
FILTER (
ALLSELECTED ( 'Calendar'[Date].[Date] ),
'Calendar'[Date].[Date] <= MAX ( 'Calendar'[Date].[Date] )
), filter(allselected(TeamsandRoles[Developer Name] ), TeamsandRoles[Developer Name] =max(TeamsandRoles[Developer Name] ))
)
RETURN
Target
Hi Amit,
I have screenshotted the following and blocked out sensitive data (i.e. names):
I think an issue might be the measure for target hours, which is the following:
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |