Model building problem

[Anonymous]

Hi all,

I am building a data model like below. And what I want is using this model to create a matrix table including, Column: job Description, Name(from Inspection team member table);  Value: Hour(from employee transaction table ). The hour I get is total rather than every employee's hour. Please help what should I do, should I change the model, or write a new measure?

Thank you in advance!!!

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

There is a problem with the filter direction between these tables.

You may need to change the relationship between 'Date' and 'Employee Transaction' to inactive relationship, and change the relationship between 'Inspection Team Memver' and 'Employee Master' to a one-to-many bidirectional relationship.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous . Common Job Table is missing. You have to create a job table with common job columns

Distinct(union(

Summarize(Employee, Employee[Job ID], Employee[Job Name]),

Summarize(team, team[Job ID], team[Job Name])

))

Correct table and column names, Add other columns. Job ID should be unique. Join with both tables on job id and use in visual

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda