Forum Discussion

cousinitt13's avatar
cousinitt13
Helper I
1 year ago

Calculating Amount of Categories within 2 fact tables

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

jobIDskillID
13
1

3

2

4

 

fact_user

userIDskillID
15
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