Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |