Combining data from two sources

Hi, Anonymous 

Based on your description, you need to go to Power Query, make 'SkillA','SkillB','SkillC' selected and click 'unpivot columns' in the 'Transform' ribbon. Then you may click 'Close and Apply'.

There is a many-to-one relationship between 'Team Skills' and 'Skill master'.

Then you may create four measures as below.

Skill Requirement for daily activities = 
var _skill = SELECTEDVALUE('Team Skills'[Skill])
return
LOOKUPVALUE(
    'Skills master'[Skill Requirement for daily activities],
    'Skills master'[Skill],
    _skill
)

Skill Required for cover/attritio = 
var _skill = SELECTEDVALUE('Team Skills'[Skill])
return
LOOKUPVALUE(
    'Skills master'[Skill Required for cover/attrition],
    'Skills master'[Skill],
    _skill
)

Total Skill Requirement = 
SUMX(
    'Team Skills',
    'Team Skills'[Skill Requirement for daily activities]+'Team Skills'[Skill Required for cover/attritio]
)

Format = 
IF(
    SELECTEDVALUE('Team Skills'[Value])<[Total Skill Requirement],
    1,0
)

Then you need to go to Visualizations ribbon, click 'Conditional formatting', make 'Value' selected, check 'Background color' on, click 'Advanced controls' and set as below.

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.