Calulate average of a measure

[Pick]

Hi,

  I have the table below.  I want to get the average of S2_Time_Between_Batches.  Cant seem to use the AVERAGE function on a measure.  Any help would be appreciated.

[v-easonf-msft]

Hi , @Pick 

Do you have resolved it? If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

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.

[amitchandak]

@Pick , Can you share sample data and sample output in a table format?

Why you can not use the average.  Then you need to have like

Sum(A)/Sum(B)

Sum(A)/count(B)

[Pick]

[v-easonf-msft]

Hi , @Pick 

Judging from your screenshot, [S2_TimeBwtweenBatches] seems like a measure.

You also can take a try this formula:

Measure  =  [S2_TimeBwtweenBatches]/COUNTROWS('Table')

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.

[harshnathani · Accepted solution]

HI @Pick ,

Measure = AVERAGEX ('Table', [S2_TimeBwtweenBatches])

Measure = AVERAGEX (ALL('Table'), [S2_TimeBwtweenBatches])

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[ThoSch-Ger]

AVERAGE needs a column and won't work with an aggregation.

https://dax.guide/average/

Try 

Calculate( Average ( Column ); Condition 1; Condition 2; ....)

and recreate the measure with the Calculate conditions