Matrix discipline vs working hours for employees

[janwillem]

I want a matrix as follow:

                            Discipline A     Discipline B     Discipline C

Employee A                5 hours         2,5 hours            -

Employee B                1 hours           -                        3 hours

Total                           6 hours          2,5 hours            3 hours

I use a date slicer from the "hour logs" (see att.)

Is it also possible to use a "project days" slicer?

I have a matrix but by every disicpline comes the same: employee / working hours per discipline.

MatrixTables + relations

How can I fix this problem?

[v-huizhn-msft]

Hi @janwillem,

From your screenshot, you use the plansysteem_XXX_pr_project_days[Date] to create a slicer, right? In the Matrix, Name filed as row levels, the Discipline as column level, what's your value level? It's a measure or column? Could you please share more details for further analysis? 

Best Regards,
Angelia