topic Re: Avg/day/store in DAX Commands and Tips

Avg/day/store

Anonymous — Fri, 01 Jul 2022 16:01:13 GMT

Hi All,
I'm trying to calculate Avg/day/store but, my number are not coming out correctly. Is anything wrong with my DAX.

Re: Avg/day/store

daXtreme — Sat, 02 Jul 2022 08:26:08 GMT

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...

Re: Avg/day/store

Anonymous — Wed, 06 Jul 2022 02:03:33 GMT

daXtreme I'm trying to calculcate Avg per day per store. Then Week Number on the column.

I'don't want the store slicer. it works with the store slicer.

Re: Avg/day/store

Anonymous — Thu, 07 Jul 2022 05:56:42 GMT

Hi Anonymous ,

Please refer this measure:

Measure = AVERAGEX ( ALLEXCEPT ( 'dim', 'dim'[store] ), [units sold] ) / 7

If it doesn't work, please share some sample data.

Best Regards,

Jay