Calculates between two tables that are linked by a third table

[Vitaliy]

Hi !

Need your help..
I have such a data model in my test.pbix file:

It is necessary to build a simple table of the following type (by every user, by every day):

What measure (or should there be a column?) should I create in order to correctly count the time of worklogs for each day and each user in the table?
That is, in the LogHours column, the time of worklogs is now line by line the same for all users in those days when it is, but it is not, in fact (

Or it would be better to build another data model, since In the future, I will need to add planned working hours (PlanHours column) for each day and consider overtime/ not-logged time as LogHours - PlanHours?
I would be very grateful for the help or advice.

[v-lili6-msft · Accepted solution]

hi, @Vitaliy 

You need to change your data model as below:

add a username dim table and then create the relationship as below:

Then drag the username from username dim table instead of "vacations_calendar" [Login]

Result:

Best Regards,

Lin

[Vitaliy]

Thanks, it helps!