Taking the average of a measure

[Anonymous]

Moving Range = 
VAR EarlierTime =
    CALCULATE (
        MAX ( 'table'[StartDate] ),
        FILTER (
            ALLSELECTED (  'Table'[StartDate] ),
             'table'[StartDate] < SELECTEDVALUE (  'table'[StartDate] )
        )
    )
VAR EarlierMeasureValue =
    CALCULATE ( SUM (  'table'[Operating Efficency]),  'table'[StartDate] = EarlierTime )
RETURN
    ABS ( EarlierMeasureValue - SUM ( 'table'[Operating Efficency]) )

I have this measure and I'm trying to take the average after it has gone through all the rows. Any ideas on how I could go about doing this?

[mwegener]

Hi @Anonymous 

is your problem solved?

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[v-easonf-msft · Accepted solution]

Hi ,  @Anonymous 

According to you description, you can try to use measure like that:

Measure = AVERAGEX(Table, Table[Moving Range])

If I misunderstood you problem ,please let me know.

In addition ,you can kindly share your sample data and expected result if you don't have any Confidential Information.

Best Regards,

Community Support Team _ Eason

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @Anonymous ,

look at this.

averagex-function-dax 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.