Avera for measure

[Justas4478]

Hi, I have measure that calculates sales with filter for stores.

 

This is the measure

Trial store Sales = CALCULATE ([Sales Value Local CCY],FILTER (

'Store','Store'[Store Number] IN {"0021","0209","0231","0342",

"0621","0691","0716","0992","0012","0098","0184","0306",

"0413","0482","0670","0680","0893","1046"}))

I am trying to change it so it would calculate Average. But dax function for AVERAGE doesnt work since I am using Sales Value Local CCY that is a measure. Anyone know how to modify measure so it would work.

Due to live conection to the dataset I dont have access to the calculated columns use in power bi. Thank you.

[amitchandak · Accepted solution]

@Justas4478 , Use some context/group by

Trial store Sales = CALCULATE (Averagex(Values('Store'[Store Number]) , [Sales Value Local CCY]),FILTER (
'Store','Store'[Store Number] IN {"0021","0209","0231","0342",
"0621","0691","0716","0992","0012","0098","0184","0306",
"0413","0482","0670","0680","0893","1046"}))

[Justas4478]

@amitchandak  Thanks this solution works.