Forum Discussion
Average Store Sales
I am looking at a day by day view of how many stores are open, their total sales, and what the average per store is in sales. I would want the week total to be different. The average per store would ...
Nevermind I got it working with
SUMX(VALUES('4-4-5 Date'[DateKey]),CALCULATE(DIVIDE([Net Sales],[# Stores Day])))
The first formula doesn't help me get to the $17,624 because I dont have # of stores for the total of the week. I need to add up the averages for each day of the week.
Anonymous - Could you share your pbix?
Unfortantely my file is full of sensitive data. I really just need a measure that can add up a daily value for the whole week. So if I have average sales on a daily level, what is the total of 7 of them each week.
Nevermind I got it working with
SUMX(VALUES('4-4-5 Date'[DateKey]),CALCULATE(DIVIDE([Net Sales],[# Stores Day])))