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

     

tonijj's avatar
tonijj
Helper IV
4 years ago

Hi Shishir22 

Thanks, it doesnt quite solve my problem though with the two tables and result 🙂

1. The relationship is already there
2. I need two different tables for this solution, otherwise I wouldve gone ahead with a normal visual. However, I use Zoomcharts drilldown visuals and therefore I need to separate the datasets as described above. 

  • Shishir22's avatar
    Shishir22
    Solution Sage
    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