Forum Discussion

Nikitun's avatar
Nikitun
Frequent Visitor
6 years ago

How can I connect these tables?

Hi! I have this model in my project. All employees are in the dictionary table 1 at the top of the model. It has ID column with unique employee's ID values, and also NAME, E-MAIL and PHONE NUMBER col...
Need Help
Show and Tell
Tips and Tricks
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
6 years ago

Nikitun 

I take it table 1 has the relevant field to identify whether they are "operators", "managers" etc..

 

If so, there's no need to create table 2 to 4. You can have a single dimension table connected to your fact tables, and when you set up your slicers, you can select the filed which identifies the "type of employee" in the filter pane to only show "operators", "managers" or whatever.

 

Does that help?