Forum Discussion

PowerBiNoob's avatar
PowerBiNoob
Frequent Visitor
9 years ago
Solved

Avg on different values in same column

Hey,   I have a Table which contains the following columns, I would like to get the average of the "SampleValue" for each of the "WhatWeek"  - example (avg 22.6 for Last Week , avg 134.5 for Curren...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi PowerBiNoob

     

    To do what you want, just create some calculated measures.  You can start with a pretty easy measure like :

     

    Average of SampleValue = AVERAGE('Table1'[SampleValue])

    And then drag this to your visual.  You can then create additional measures for your previous week, and difference metrics

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi PowerBiNoob

 

If you drag your 'WhatWeek' to the report canvas and change your visual to be Table or Matrix.  Then drag the SampleValue column to the same visual, the default behaviour will be SUM.  Then click on the SampleValue field in the values area and change the default aggregation to Average.  This will work the same for other visuals.

 

PowerBiNoob's avatar
PowerBiNoob
Frequent Visitor
9 years ago

Thanks for the response , I need to use the values in a  KPI visual to get the avg diff between current and last week, but doing what you suggest works fine for table display...thank you again

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi PowerBiNoob

     

    To do what you want, just create some calculated measures.  You can start with a pretty easy measure like :

     

    Average of SampleValue = AVERAGE('Table1'[SampleValue])

    And then drag this to your visual.  You can then create additional measures for your previous week, and difference metrics