Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Standard Deviation Part 2

Hi Expert   here is the link to the fist part of the question which an expert Ash solved and provideed excellent feedback.  https://community.powerbi.com/t5/Desktop/Standard-deviation-of-a-calcula...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Does this mesure work?

    =1.96*[Revised]/(DISTINCTCOUNT([HP Outome Type])^(1/2))

    Revised is the measure which returns 6.5 in the last column.  HP Outome Type is a column.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

I'd like to help but am not clear about your desired result.  What should the value of the mean be i.e. the X bar?  Do you want this for each year or for all years put together?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ash

 

the x bar is the upper and lower limits of the total std dev so for "Revised" the Std Dev is 6.5, its the upper and lower bands for that.. n 1s the total observations in this case 12977.

 

and its not caclulated for each yr. many thanks once again.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

    Does this mesure work?

    =1.96*[Revised]/(DISTINCTCOUNT([HP Outome Type])^(1/2))

    Revised is the measure which returns 6.5 in the last column.  HP Outome Type is a column.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      hi Ash, let me test and come back to you.