Additional relationship by date

[gerasimovav]

Hello coleagues!

I have this model:

There are three tables:

public vw_users containes information about users.

work_tabel containes information about working hours per monthes (june 2018, july 2018, august 2018 ect) of this users

public vw_reports contains information about daily action of this users including action data, time spend etc.

work_tabel has relationship with public vw_Users by TableNumber (its another user id) as you can see.

public vw_reports has relationship with public vw_Users by user id

work_tabel and public vw_reports are also linked by date. But this relationship is disabled, because of this two tables are already linked by user through public vw_users.

I have to got a report work hours and time spend by user

I've created this report

but slicer data (from public vw_reports.data) doesn't influent on workhours because of inactivity tables by data.

I consider a solution which provide me filter workhours by the data slicer.

I have a lot of same cases, where tables have already relationships by different columns, and I have to filter it by date by common slicer.

Thank you for help.

[v-yuta-msft]

Hi gerasimovav ,

You should buid a one-to-many relationship between public vw_Users by and work_tabel and try again.

Regards,

Jimmy Tao

[gerasimovav]

Hi, @v-yuta-msft!

Thank you for reply.

I've already built the relationship between public vw_Users and work_tabel by TableNumber (its another user id). This one marked yellow:

Do you mean I have to build another one? 

[gerasimovav · Accepted solution]

I've solved that problem. The solution is to leave inactive relationship and create new measure with calculate - userelationship function. For more details please visit https://carldesouza.com/power-bi-dax-userelationship-multiple-dates/