Forum Discussion
Anonymous
3 years agoNot applicable
Incorrect row total...
Hi All,
Please help with incorrect row totals and the overall total is correct.
- Below in the Tabel 1, the base line hours are incorrect as soon as I add the client name (there are many clients).
- Tabele 2 baseline hours are correct without client names.
- Employees have coded several clients along with Non-Billable code where baseline hours appears correct in Table 1 and not for client names.
- Leaves and holidays become zero (table 1) as soon as i add the client name.
- Baseline hours = days worked * weekly scheduled hours - Leaves and holidays (dax measure).
- Days worked calculated using dax : Measure =
COUNTROWS (
FILTER (
'Calendar',
'Calendar'[Date] >= MAX ( MAX ( Utilization[Hire Date] ), MIN ( 'Calendar'[Date] ) )
&& [Weekday] <= 5
)
) * 8
Tabel 1 : Incorrect baseline hours Tabel 2 : Correct baseline hours.
1 Reply
- lbendlinSuper User
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523