Forum Discussion
Issues with data hierachy/multiple columns in matrix visualization
Hi Anonymous ,
Please recreate a new measure.
Measure 2 = var aa = IF(SELECTEDVALUE('Table'[PARENT_TEAM])<>BLANK(),SELECTEDVALUE('Table'[PARENT_TEAM]),SELECTEDVALUE('Table'[TEAM_SHORTNAME])) return if(ISINSCOPE('Table'[TEAM_SHORTNAME]),[Measure],CALCULATE(MAX('Table'[TEAMLEAD]),FILTER(ALL('Table'),'Table'[PARENT_TEAM]=BLANK()&&'Table'[TEAM_SHORTNAME]=aa)))Then filter the PARENT_TEAM.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the quick response Anonymous .
My raw data does not differentiate between Teamleads and Department Heads, they are both in Column TEAMLEAD. However, via my TEAM_ID and PARENT_TEAM_ID my data implies a hierarchy with parents being departments and children being teams.
ADWS1 for example is parent to all other teams (=> department of those teams) and has Angela Merkel as a teamlead (=>department head).
Ideally the department head should show up in the same column in my visualization as the teamleads of the child teams under it (as shown in the attachment to my last reply).
However, I'm open to alternative solutions if that's not possible.
Thanks!
Marcel
Hi Anonymous ,
Please recreate a new measure.
Measure 2 = var aa = IF(SELECTEDVALUE('Table'[PARENT_TEAM])<>BLANK(),SELECTEDVALUE('Table'[PARENT_TEAM]),SELECTEDVALUE('Table'[TEAM_SHORTNAME]))
return
if(ISINSCOPE('Table'[TEAM_SHORTNAME]),[Measure],CALCULATE(MAX('Table'[TEAMLEAD]),FILTER(ALL('Table'),'Table'[PARENT_TEAM]=BLANK()&&'Table'[TEAM_SHORTNAME]=aa)))
Then filter the PARENT_TEAM.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey Anonymous ! I'd have to ask another question regarding this topic. If I had more than one level in my hierarchy, how would I need to adjust the measure(s)? E.g. I have ADWS1 as my department, ADWS11 as a team an ADWS111 as a subteam. The PARENT_TEAM_ID to ADWS11 is not blank and I had issues figuring out how to adjust your measure.
Please find attached the raw data:
TEAM_ID TEAM_SHORTNAME PARENT_TEAM_ID L1 L2 L3 TEAM_LONGNAME TEAMLEAD TASK_COMPLETION HAS_TO_DO_TASK PATH 1 ADWS1 ADWS1 Software Department Angela Merkel False 1 11 ADWS11 1 ADWS1 ADWS11 Software Team 1 Max Mustermann False 1|11 111 ADWS111 11 ADWS1 ADWS11 ADWS111 Software Subteam 11 Maxime Musterfrau 1 True 1|11|111 112 ADWS112 11 ADWS1 ADWS11 ADWS112 Software Subteam 12 Barack Obama 1 True 1|11|112 12 ADWS12 1 ADWS1 ADWS12 Software Team 2 Paul McCartney 1 True 1|12 13 ADWS13 1 ADWS1 ADWS13 Software Team 3 Shawn Carter 1 True 1|13 14 ADWS14 1 ADWS1 ADWS14 Software Team 4 John Lennon 0 True 1|14 Again, I would need to have the Teamleads (Max Mustermann for ADWS11 and Angela Merkel for ADWS1) in the same column:
Any idea is greatly appreciated!
Cheers
Marcel