Incorrect row total...

[Anonymous]

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. 

[lbendlin]

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-...
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