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.
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