Split and Summarize data

Hi,

Just can't find this specific issue when searching the forum. Hope anyone can help me!

Here is what I got:

Table 1 = Score table with scoring per person and per question, where the question has a unique identifier.

Table 2 = People Table with the name and department

Table 3 = Question table with the questions and some dimensions to that.

The scoring (Table 1) has two different dimension; 
-Scoring per Importance
-Scoring per Performance

What I want to achieve:
To have 1 column or measure that consolidates all the scoring for a specific Department. 

This is the wanted end state. For me it really doesnt matter if its DAX or in the Query

End result that I want to achieveEnd result that I want to achieve