Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am working on a projectmanagement dashboard. The problem is as follows. I have a Fact table [planning] and a fact table [hours] both are connected to my dim table [employees].
Employees
id | name |
1 | Joe |
3 | Jane |
Fact table Hours
Employee | Project | Hours |
Joe | a | 8 |
Joe | a | 2 |
Jane | a | 3 |
Jane | a | 5 |
Fact table Planning
Employee | Project | Hours |
Joe | a | 8 |
Now I want a measure to give me the hours from the Hours table for employees that are not planned on that project. The result should be: Jane, a, 8
I have tried the following measure but power bi runs into memory problems:
Solved! Go to Solution.
Here's a full solution:
https://1drv.ms/u/s!ApyQEauTSLtOgZlKHry2_uC_CkFTUg?e=Ds6HQO
For simple performant code your model has to be correct (star schema). Let me know if the solution I've given you is fast enough. If not, there is still room to make it faster.
Cheers.
Here's a full solution:
https://1drv.ms/u/s!ApyQEauTSLtOgZlKHry2_uC_CkFTUg?e=Ds6HQO
For simple performant code your model has to be correct (star schema). Let me know if the solution I've given you is fast enough. If not, there is still room to make it faster.
Cheers.
Thankx!!!
@BobKoenen Maybe:
Unplanned Column in Hours =
VAR __Project = [Project]
VAR __Employee = [Employee]
VAR __ProjectEmployees = DISTINCT(SELECTCOLUMNS('Planning',"Employee",[Employee]))
RETURN
IF(__Employee IN __ProjectEmployees,1,0)