Calculating Amount of Categories within 2 fact tables

[cousinitt13]

Hello, 

I'm litte stuck with some new PowerBI calculations. 

I have two fact tables, one table is relation from job to skills, the other one is a relation table from user to skills
fact_job

jobID	skillID
1	3
1	3
2	4

fact_user

userID	skillID
1	5
2	5
3	3

also I have the dimension tables for job, user and skill

I want to calculate, which job can the user do and what skills he currently have within this job. 
so, only count Yes(1) for the jobskills, when the user has every skill for the job. 
also which skill is missing for this job. 

Help appreciated. 

thanks
Roman

[cousinitt13]

the above tables are the examples, there is nothing more to show 🙂

[MattiaFratello]

Hi @cousinitt13, could you please provide an example of data?