Average measure that updates with slicers

[Sveina]

I have a realtively simple data table with three variables, they are "Segment", "System" and "Price".  I am using "Segment" as a slicer. In addition I have created a measure "Average", and it is the average of "Price". 

I want the average to be recalulated when applying a slicer, but are not able to do that. For example if I apply "Mikrobedrifter" the average measure should update (to show the average within the chosen category), hence it should be 10,13, and not 11,30 (total average). 

Hope someone know how to solve this. Any help would be much appreciated.

The data looks like this

[amitchandak · Accepted solution]

@Sveina ,

A measure like

= calculate(Average(Ark1[Price]), allselected())

should help

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Sveina]

Hi @amitchandak 

That did work perfectly, thank you! Your help is much appreciated 🙂