Forum Discussion
cousinitt13
1 year agoHelper I
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
| 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
2 Replies
- MattiaFratelloSuper User
Hi cousinitt13, could you please provide an example of data?
- cousinitt13Helper I
the above tables are the examples, there is nothing more to show 🙂