Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Standard Deviation Flag

I am trying to get a 0 or 1 indicator if a value falls one standard deviation outside the mean for a variable period of time that can be changed.  I know this can be done for a column, but can it be ...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

You may create a measure like below:

Measure_ = IF(MAX(Table2[Value])>[Standard Deviation],1,0)

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This response doesn't allow me to use a measure as Table 2[Value], it needs a column.  Is there a way to use a measure instead of a column here?

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Anonymous 

      You may try below measure.If it is not your case,please share some sample data and expected output which could reproduce your scenario.

      Measure_ = IF([measure1]>[Standard Deviation],1,0)

      Regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I think I was unclear, this did answer my initial question.  However, the actual solution that I need would be comparing the variance of a measure over time to the standard deviation.

         

        Example:

        Standard Deviation of Measure = 14.7%

        Measure Yesterday = 80% (this measure can be looked at every day, by week, by month, and by year)

        Measure Last Week: 85.4%

         

        I want to see if the change in the measure day over day, week over week, month over month > the standard deviation for that period, and if so flag 1. 

         

        Let me know if this makes sense.

         

        I really appreciate your help!