Forum Discussion
Many-to-many / all values
Hello,
I'm working on analysis of skills and roles of people from my organization. Data about skills are taken from one source and roles from another one. I'm looking for a solution to list all the values from one table (People & Skills) to be display under values from another table (Roles). So for example I have a role of Data Analyst and I would like to see all the distinct skills that people who have this role assigned have. I've experimented with different relations but unfortunately I'm only able to get the number of roles but not their names.
Below is my model.
I will be grateful for any advice.
3 Replies
- lbendlin
Super User
Depending on the business questions you are being asked to answer you may have to create separate data models or you need to use measures where you bend the relationships temporary with the CROSSJOIN function. Personally I would treat "Roles" as an independent dimension.
lbendlin Thanks for replay. My business goal here is to show what skills people have with particular role. Here is example.
I have two users that have roles above - IT Consultant and Data Analyst. I need to show that someone who has role 'Data Analyst' assigned have skills like 'Power BI'(2), 'Tableau'(1) and 'Python'(1). It would be perfect co count that and pick some top-n.
- lbendlin
As I mentioned - that requires bidirectional many to many relationships, best implemeted via measures and CROSSJOIN modifiers. Also read about TREATAS.
