How to link two tables for using filters from one

[Anonymous]

I have two data tables

1. Actual Hours (this has a lot more columns than Expected Hours table)

1. Expected Hours

The two tables currently linked through [Employee Dim] and [PO Dim].

DAX for Hours Diff used is:

I am trying to show the difference between the Actual hours and the Expected hours. This is proving difficult.

The issue is my filters are all from Actual Hours table (eg. Manager). When these are used they don't seem to filter out the irrelevant data…

eg.

X - axis is "Employees"

in this visual I only want to show the employees that's under, say Manager A. Not all the employees. I am not sure if it's the way the tables are linked or the way the DAX is written. 

Hoping someone can shed some light on what I can do to correct this. 

[amitchandak]

@Anonymous , You need to create common table like Employee(Employee manager) , PO, Date/Month and analyze data against common dimension

then sum('Expected Hour'[Hours])  - sum('Actual Hour'[Hours])

should work

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

Try to me in Star Shema

https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

[Anonymous]

Hi @amitchandak 

Thanks for the quick response. I have two 'common' tables for Employees and PO, which are then linked to both tables in question (as mentioned above). 

[amitchandak]

@Anonymous , Date is also needed, Then you can add employee, manager from employee, PO and date from date and measure like this one

sum('Expected Hour'[Hours]) - sum('Actual Hour'[Hours])

In a visual

[Anonymous]

Ah good point.. dates were also joined through a Date table, but I'd used the wrong date field in table one. Fitlers working now thanks.  But the amount brought back when I use 
sum('Expected Hour'[Hours]) - sum('Actual Hour'[Hours])

is the same for each field.