STDEVX.P measure with missing dates

[PKPK90]

Hi,

I am trying to calculate standard deviation for dynami period of time. User will use slicer to filter dates, then measure will calculate standard deviation based on selection. I might be simple but, my sales is not continious, so for some weeks I do not have values.

This is my measure. I am trying to get all weeks between dates and pull 0 when there is no data.

QuantityADJ =

IF(ISBLANK(SUM(MaterialTransactions[Quantity])),0,SUM(MaterialTransactions[Quantity]))

Standard Deviation ADJ = CALCULATE(STDEVX.P(MaterialTransactions,MaterialTransactions[QuantityADJ]),ALLSELECTED('Calendar'[Week]))

It looks like it is taking into accout only weeks with quantity, it is ignoring 0. Result should be ~33 but it is showing ~51.

Any advice?

[wdx223_Daniel]

try this

STDEVX.P(MaterialTransactions,MaterialTransactions[QuantityADJ]+0)

[PKPK90]

Thanks for your feedback but it is not working.