Data Modeling Two Tables 1 to many

[Anonymous]

Hi everyone,

I'm struggling with the following issue:

I have two tables:

- dimension table with unique combination employeenumber-cost centre, employeenumber and cost centre

- fact table with unique employeenumber-cost centre, employee number, cost centre, weeknumber and number of classhours

The relationship between the two tables is one to many (unique combination employeenumber-cost centre is key)

One row from the fact table is shown below:

When I'm putting the employeenumber from the dim table together with classhours from the fact table it just shows up like this:

That's fine. 

When I want to add the costcentre, it's turning empty:

That's weird, because this employee has classhours in a certain cost centre..

It's neither showing up when I just add the unique combination of employeenumber/costcentre

Does anyone know why this is not showing up?

Thanks!

[amitchandak]

@Anonymous , Hope the cost center is coming from dim and it sum/Some Agg of number of classhours.

Ideally, it should work.

If measure has some calculation you need to share

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.