Avg on different values in same column

[PowerBiNoob]

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 Current Week) ? Regards

SampleValue	TimeSampled	WhatWeek
37.24023438	13/07/2017	Last  Week
7.130859375	13/07/2017	Last  Week
50.12597656	13/07/2017	Last  Week
20.20410156	13/07/2017	Last  Week
17.3984375	13/07/2017	Last  Week
3.622070313	13/07/2017	Last  Week
5.86328125	18/07/2017	Current Week
311.0576172	18/07/2017	Current Week
281.6513672	18/07/2017	Current Week
52.58007813	18/07/2017	Current Week
63.43066406	18/07/2017	Current Week
7.907226563	18/07/2017	Current Week
219.1425781	18/07/2017	Current Week

[Phil_Seamark]

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]

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 · Accepted solution]

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