Forum Discussion
Calculating average including blanks
Ok, so what I ended up doing is creating a sales = calculate(sum(Dollar Sales)) and another one is number of weeks =distinctcount(dimdate[week in year]) and then divide (sales,number of weeks) to the the correct average then I filter on the page for number os specific weeks (Last 4 weeks, last 10 weeks etc).
Thanks for giving me the idea to create the seperate measures and then divide them.
You will need to supply appropriate arguments.
If you need more specific help, it would help if you can upload sample model.
Ok, so what I ended up doing is creating a sales = calculate(sum(Dollar Sales)) and another one is number of weeks =distinctcount(dimdate[week in year]) and then divide (sales,number of weeks) to the the correct average then I filter on the page for number os specific weeks (Last 4 weeks, last 10 weeks etc).
Thanks for giving me the idea to create the seperate measures and then divide them.