Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Need help on DAX to calculate Average for below measure.
DAX for the measure is below.
MovingRange = IF(ISBLANK(data1[EarlierTime]);blank();( VAR EarlierTime = CALCULATE ( MAX ( data1[TimeSPC] ); FILTER ( ALLSELECTED ( data1[TimeSPC] ); data1[TimeSPC] < SELECTEDVALUE ( data1[TimeSPC] ) ) ) VAR EarlierMeasureValue = CALCULATE ( SUM ( data1[MeasureValue] ); data1[TimeSPC] = EarlierTime ) RETURN ABS ( EarlierMeasureValue - SUM ( data1[MeasureValue] ) ) ))
End goal is to calcuate Sigma, = MRbar/1.128.
- MRbar= Average of Moving Range.
- 1.128 is a constant.
Sample Pbix file
https://1drv.ms/u/s!ArjVwEnHONXNghx02BIdTGGtSrlZ
Solved! Go to Solution.
Answer:
MRBar = AverageX(ALLSELECTED(data1[TimeSPC]);[MovingRange])
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |