Forum Discussion

SimonKibsgaard's avatar
SimonKibsgaard
Helper I
9 years ago
Solved

Sum up data in calculated table

Hi I have a table with survey data. I am using Power BI Visualizations to show this data and segment by groups. When I do page level filtering of eg one company's data, I am no longer able to show ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi Simon,

     

    Give this a crack...

     

    New Table = SUMMARIZECOLUMNS(
                            --- Group By ----
                            'Table1'[Company Name],
                            --- Aggregations ----
                            "Average Result" , AVERAGE(Table1[Survey Result])
                            )
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi Simon,

 

Give this a crack...

 

New Table = SUMMARIZECOLUMNS(
                            --- Group By ----
                            'Table1'[Company Name],
                            --- Aggregations ----
                            "Average Result" , AVERAGE(Table1[Survey Result])
                            )
SimonKibsgaard's avatar
SimonKibsgaard
Helper I
9 years ago

Works! Thnx a lot.