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])
                            )
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi SimonKibsgaard,

My idea for a solution was to calculate a new table with company names and their averages based on the initial table - and then reference those values in my reporting - as I believe they will not be affected by the report filter. 

Yes, calculate table\column is evaluated during the database processing(like data refresh), it won't be affected by the report filters. And the formula provided by SimonKibsgaard should work in your scenario.:smileyhappy:

 

Regards