Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi Jimmy

 

the issue is i cannot get the same confidence intervals, i have tried Norm, two tail Z test, t value all the necessary statistical formula under the sun. 

 

Wht i have not managed to do is break the R Code down, to see what it is doing on [6] * 100 part.