Forum Discussion
DAX STDEV.P giving wrong value
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
Hi FergalK,
Couldn't reproduce your issue. The STDEV.P works well on my side.
Regards,
Jimmy Tao
Hi Jimmy
Thanks for the reply, it does seem strange that it does not work correctly for me.
The only real difference is that you are using the formula in PowerBI and I am using it in SSAS tabular model but they should yield the same value.
I am wondering if it is not being calculated correctly in my pivot table because it does not recognise the filters correctly? But note thatr the Stdev value does actually change when I change a filter value in the pivot table, so it does seem like it acknowledges the filter values
Fergal
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