Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In my file I connect PROJECTS-OPENHOURS (contains the projects where there is still room for activities, no employee knwon yet, I filled in with an "empty"-emplyee ) with PLANNING (contains the planning of employees on their projects).
Matrix 1A is OK.
But when I drill down I get open hours for the specific employee while they don't have open hours (see Matrix 1B)
So I tried ISINSCOPE in Matrix 2A.
2A is OK, but in 2B I get other problems (see Matrix 2B): all employees are repeated for each project. And the Open hours per project is missing.
Solved! Go to Solution.
Thanks for the suggestion with HASONEVALUE.
It gives a nice possibility in the non aggregated lines. In the hierarchie is has the same effect and does not solve the problem.
It triggered me to look for another solution. With appending the two data-tabels into one table I solved it.
@bavix Odd. PBIX might help. Try:
SWITCH(TRUE(),HASONEVALUE(Employees[employee]),"", [plan / open])
Thanks for the suggestion with HASONEVALUE.
It gives a nice possibility in the non aggregated lines. In the hierarchie is has the same effect and does not solve the problem.
It triggered me to look for another solution. With appending the two data-tabels into one table I solved it.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |