How to map two data sets in a data model

[Jairacha]

Hi All! 

I am trying to create a skills dashboard to map out differnet skills of employees within my department. I currently have two tables, Table1 is the results from the Msft Forms survery that employees must fill out and Table2 is my hierarchial filter table that will allow dashboard users to filter on differnt skillsets found in Table1. I am having difficultly trying to map the two tables together so that if someone filters on Table2, the filtered results should come accross on the visual using data from Table1. Below are screenshots of my two tables. Could someone pls help with how to map the two tables or if there is a better way to do this? Basically, I would like to filter on the different Skill Levels found in Table2 so that these employees would be filtered on Table1.

Table1:

Table2:

Thank you!!

[jdbuchanan71 · Accepted solution]

@Jairacha 

Take a look at this article from DAX Patterns on survey data.  https://www.daxpatterns.com/survey/

You have a good start with your second table, I think you just need to organize your responses table vertically.

Basically, the pattern is, each question / answer pair is assigned an unique answer key.

Finance Organizational Evaluation / N/A is 1
Finance Organizational Evaluation / Beginner is 2
Cost Take Out / Beginner is 22
Cost Take Out / Experienced is 23
Cost Take Out / Advanced is 24
etc.

Then you map the answer keys to the employee based on thier responses.

It's all covered in that article.

[Jairacha]

this works! thank you!