I have a matrix with line manager at the top row, below there are employees under this manager and project descriptions
The values are billable and unbillable hours. I'd like to have count of unbillable hours only for the line manager row and maybe a employee, however it gives me value of same hours for each line of project description, while there might be only one with unbillable hours
Both values are measures made of SUM(billable) or SUM(unbillable). However I think it might be model issue, because unbillable hours are not connected in any way to project, right? If yes and I cant overcome it (not DE myself, no access to DB), then can I have some dax workaround?