Avg/day/store

Hi Anonymous

You've given too little context to answer this question. And the DAX is not correctly formatted, hence hard to read. No idea why you'd like to add Dim[Store] as a filter to CALCULATE. CALCULATE only takes tables as filters, not columns. But you could try this:

Avg Per Day =
averagex(
  values( 'Date'[calendar_date] ),
  [Units Sold] / 7 -- why divide by 7?
)

If you slice by Store, this should give you what you want in the current context. I also understand that [Units Sold] is a measure...