Forum Discussion

tonijj's avatar
tonijj
Helper IV
4 years ago
Solved

Split and Summarize data

Hi,   Just can't find this specific issue when searching the forum. Hope anyone can help me! Here is what I got:   Table 1 = Score table with scoring per person and per question, where the que...
Need Help
  • Shishir22's avatar
    Shishir22
    4 years ago

    Hello tonijj ,


    If you want to bifurcate score table you can create two calculated table as -

     

     

    SummaryTable1HR = 
Filter(ADDCOLUMNS('Score Table',"_Dept",RELATED('People Table'[Department])),[_Dept]="HR")

     

     

     

    SummaryTable1Dominance = 
Filter(ADDCOLUMNS('Score Table',"_Dept",RELATED('People Table'[Department])),[_Dept]="World Dominance dept")

     

     

    Please mark it as solution if it resolved your issue. Kudos are also appreciated.

     

    Cheers,

    Shishir

     

Shishir22's avatar
Shishir22
Solution Sage
4 years ago

Hello tonijj ,

 

Step 1- Give relationship between score table and people table on name.

Step 2- Create 2 table visuals and apply visual level filter of departement from people table for HR and World Dominance Dept on respective tables.

 

You should get required output.


Please mark it as solution if it resolves your issue. Kudos are also appreciated.

 

Cheers,

Shishir

tonijj's avatar
tonijj
Helper IV
4 years ago

Shishir22 

Thanks a bunch, that did the trick! 

I was going about this the wrong way, trying to use "summarize" or "summarizetable" then together with a filter. 

EDIT: Thankfully I didnt have more than 2 departments, otherwise this would have been...troublesome 😕 
Thanks again!