Forum Discussion
Extreme Values, percentile or std deviation as filter
Hi Experts
I am having exterme difficult in calculating the upper and lower in power bi. I can work out the mean of the data which is correct for all Stem Bands. I have the std deviation, which i believe to be correct (see measure 2 in attached).
I have the numver of observation 2243 for total data set
i have the total number of observation yr 376437
when i plug these numbers into a inherited R Script See below...the person who wrote the R Script has moved on
its gives me the correct lower and upper confidence intervals (see below)
in order to get the above values you might need to remove filter on the pbix file, if it is already filtered to Polar Stem (stem Brand filter)
Question does anyone now the power bi eqiv of Prop.Test or the Maths behind the R Scirpt. Or can some one check over measure 2 that works out the Std Deviation based on the Primaryoutcomeyears.
https://www.dropbox.com/s/3gdtorbkanpdp2i/Test__%281%29.pbix?dl=0
2 Replies
v-yuta-msftCommunity Support
Anonymous ,
I have the numver of observation 2243 for total data set
i have the total number of observation yr 376437
when i plug these numbers into a inherited R Script See below...the person who wrote the R Script has moved on
its gives me the correct lower and upper confidence intervals (see below)
in order to get the above values you might need to remove filter on the pbix file, if it is already filtered to Polar Stem (stem Brand filter)
Question does anyone now the power bi eqiv of Prop.Test or the Maths behind the R Scirpt. Or can some one check over measure 2 that works out the Std Deviation based on the Primaryoutcomeyears.
I have checked Prop.Test in R reference and can't find similar dax functions. So what's the issue when you use
STDEVX.P() in your report? Could you clarify more and show the expected results?Regards,Jimmy Tao