Forum Discussion
Matrix same values assigned to every row
Hello,
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?
2 Replies
can u provide sample data?
billable hrs table sample
EmpID EmpName Billable hours 1 John 10 2 Steven 10 3 Anna 10 4 Monica 10
Project table sample
ProjID EmpID ProjDsc ID1 1 Project1 ID2 1 Project2 ID3 2 Project3 ID4 3 Project4 ID5 4 Project5 Nonbillable hours table
EmpID NonBillableHours ID1 5 ID3 5 Really straighforward. Employee can have nobillable values in several rows etc
Then I create a matrix with emp name, projectdesc as rows, billable nobillable horus as values
and now, because ID1 has 5 nobillable hours, it shows that it has "5" nobillable hours under his projectdesc, when I want it only at the name level, not when I expand the projectdesc
