Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Issues with data hierachy/multiple columns in matrix visualization

Hello all,   I am experiencing the following problem:   Each month I check, whether all teams within my organization have completed a specific task. I have constructed a report that allows me to ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous .

Please have a try,

Create a measure.

Measure = SELECTEDVALUE('Table'[TEAMLEAD])

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks a lot Anonymous ! I could recreate this with ease in my file 🙂 

     

    At least there is no more incorrect teamlead shown at department level. Is there a way however to show the department head there also? See below:

     

    Appreciate any help! Thanks and kind regards

    Marcel

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous ,

      Where do you want to show the department head? And which column is the the department head? Please provide your desired output.

      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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