Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data Modeling Two Tables 1 to many

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 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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.