Forum Discussion
DAX STDEV.P giving wrong value
Hi I have a formula in my Tabular SSAS model to calc. the Std. Deviation as follows: RMAQtyStdDev:=CALCULATE (STDEV.P(drct_rtns[rma_rcpt_qty] ), ALLSELECTED(drct_rtns)) ..but it is giving ...
I have rewritten my source query to combine both columns into a single column - issue was that zeros in other column were causing inciorrect average to be calculated
Actually I think I may know what the issue is, it seems like the STDEV is including zero values too - how could I alter for formula to remove zeros from the STDEV calc?
thanks!
RMAQtyStdDev:=CALCULATE (STDEV.P(drct_rtns[rma_rcpt_qty] ), ALLSELECTED() )
I have rewritten my source query to combine both columns into a single column - issue was that zeros in other column were causing inciorrect average to be calculated