Forum Discussion
Problem with blank values in combination with filter
Hello,
I tried several ways but still get them same result that i don't want, hope someone can help me out 🙂
Situation:
4 tables :
- DIM table with employees and more info of them (including which team)
- DIM table with skills, where every employee have his unique skill
- Calendar table
- Forecast table Where the data is if an employee is booked on a project or not, each line is booked as a half day with date and more info which project and kind of project.
Problem:
Ideal situation is to have a table where you have first the skill (Coming from Skills table) next the name of the employee (coming from the employee table) . Columns are the number of weeks. and the value in the column is => 5 working days - the already booked days.
Added 1 column =
- in the forecast table added a column where every cell is 5
I created 2 measure =
- Working_days = CALCULATE(MIN(FACT_FORECAST[Workingdays]))
- Not_planned = CALCULATE(IF([Days_booked]>0;[Working_days]-[Days_booked];[Working_days]))With this formulas i'm able to have an overview where i see the => 5 working days minus the already planned days;But the problem is that the report show a blank value if there is nothing planned yet in that week.
I tried to solve this with follow measure but the problem is that he show in every skill all people, but the calculation for the related person is correct but al other persons have 5 and don't need to be in it.
Has someone any idea how to have a value ( => 5 ) in the table when there is not booked anything for the related person in that week?
Thanks!
Kind regards
- Anonymous6 years ago
Hi Icey,
Thank you for your reply, i solved it in the meantime to add a table with for every user a target of 1 on every working day. This allowed me to make a measure that also give a numer when it was blank.
Kind regards
2 Replies
- IceyCommunity Support
Hi Anonymous ,
I tried to solve this with follow measure but the problem is that he show in every skill all people, but the calculation for the related person is correct but al other persons have 5 and don't need to be in it.
What measure did you use?
And if you don't mind, please share me a dummy PBIX file without real data or sensitive information. Then I can help you better.
Best Regards,
Icey
- AnonymousNot applicable
Hi Icey,
Thank you for your reply, i solved it in the meantime to add a table with for every user a target of 1 on every working day. This allowed me to make a measure that also give a numer when it was blank.
Kind regards