Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.