Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vincentakatoh
Helper IV
Helper IV

Average of Measure

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

1 ACCEPTED SOLUTION
vincentakatoh
Helper IV
Helper IV

Answer:

MRBar = AverageX(ALLSELECTED(data1[TimeSPC]);[MovingRange])

View solution in original post

1 REPLY 1
vincentakatoh
Helper IV
Helper IV

Answer:

MRBar = AverageX(ALLSELECTED(data1[TimeSPC]);[MovingRange])

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.