Forum Discussion
Getting correct Average Sales Quantity by Week when data is blank
Hi, I am trying to capture the average sales quantity per week by product. The challenge is to include the weeks when there is no data. I know that i will need to use ALL or VALUES for the w...
Thank you so much. My table is like your first example where the week (entire row) is missing.
I would prefer to have a dax function that uses the AVERAGE function instead of manually inputting the denominator. This is because I will also need to capture standard deviation (which will need to include the missing week).
Hi carguello726 ,
I dont think Average function can match for this case since the entire row is missing. You can also use the second measure to get the same result. If you want to calculate standard deviation, you can set the measure result as a variable to use.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.