Standard Deviation Flag

Question

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 done for a measure?

Can provide more detail if necessary

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
You may create a measure like below:
Measure_ = IF(MAX(Table2[Value])&gt;[Standard Deviation],1,0)

Regards,

anonymous · Answer

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

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
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]&gt;[Standard Deviation],1,0)
Regards,

anonymous · Answer

I think I was unclear, this did answer my initial question.&nbsp; However, the actual solution that I need would be comparing the variance of a measure over time to the standard deviation.&nbsp;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%&nbsp;I want to see if the change in the measure day over day, week over week, month over month &gt; the standard deviation for that period, and if so flag 1.&nbsp;&nbsp;Let me know if this makes sense.&nbsp;I really appreciate your help!

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
It seems you need to get the measure of last year,week.Below are some reference for you.
https://community.powerbi.com/t5/Desktop/Calculate-Week-over-Week-change-based-on-Number-of-weeks-since/m-p/587282#M278396
https://community.powerbi.com/t5/Desktop/Variance-between-two-measures/m-p/588970#M279325
Regards,

Forum Discussion

Standard Deviation Flag

5 Replies

Related content

Standard Deviation

Standard Deviation DAX

Standard Deviation of total sales

Standard Deviation

Standard Deviation