Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello PB colleagues,
In PB desktop I’ve got a grid visual with available hours for direct billable staff, on a weekly basis. (working hours per week minus deployed on project). This Is based on a calculate sum of values of existing rows per employee in the corresponding week. So far, nothing wrong.
If there is no projectacitvity in the specific weeknumber, the value in the grid is logically a white space.
My question is: how to replace the white space by the employee hours based on labor contract in the grid, based on a related table property?
Thank you!
Screendump:
The value is calculated with a column:
Inzetperweek =
CALCULATE (
SUM ( 'WorkSchedule'[InzetUren] );
ALLEXCEPT (
'WorkSchedule';
'WorkSchedule'[OwnerId.Id];
'WorkSchedule'[Week];
'WorkSchedule'[Jaar]
)
)
Further explination in my reply Eric Zhang.
The thumbnail is blurred and currently I can't enlarge it as usual, there might be some problem in this forum. So I can't get what exactly you're talking about.
The visual in your snapshot looks a custom visual, can you type its name so that I can download and test.
Regarding replacing, maybe a measure like IF(Inzetperweek=0,someOtherExpresionToGetTheProperty ,Inzetperweek) would work, someOtherExpresionToGetTheProperty depends on what the dataset like in your case.
Hello Eric,
Thanks for responding Eric! It's a matrix grid in PB, not a custom visual. I blurred a few names and added some explanation in the screendump: Download
is there a way with a measure to drill down to a specic column value (record based) in a related table, based on systemuserid if their aren't any project (planned) activities in the time span?
Because sometimes no records exists in workschedule (blank values in screendump), I can't use a calculated column in workschedule.
Measure pseudo , but don't no if this kind of logic is possible in PB:
Measure = IF Inzetperweek ISBLANK in timespan visual SEARCH column value laborhours in related table systemuserset WHERE workschedule.systemuserid = systemuserset.systemuserid ELSE workschedule.Inzeturen
Any ideas?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |