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,
I have created a measure to calculate the number of weeks colleagues are behind on timesheets:
Solved! Go to Solution.
Try it like this.
Weeks Overdue Totaled =
SUMX ( Contacts_Table, [Weeks Overdue] )
You use your existing measure and iterate over the contacts table so the totals add up correctly.
Try it like this.
Weeks Overdue Totaled =
SUMX ( Contacts_Table, [Weeks Overdue] )
You use your existing measure and iterate over the contacts table so the totals add up correctly.
The Timesheet_Report contains Contact ID, which have a relationship with a seperate data table that includes the ID and contact name. The Contact ID then has a second relationship with another data table with includes the contact ID and team ID and the the team ID is joined to another dataset that has the team ID and the team name. How do you propose the SUMX code looks? Because the numbers I want to summarise come from the difference between the last submission and the end of the previous week. I tried...
How is your data laid out? Do you have your teams and members in a separate table that is linked to the Timesheet_Report? You will need to used a SUMX with your measure to calculate the correct subtotals.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |