Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
126 | |
110 | |
87 | |
70 | |
66 |