average from list of a measure

[zraopingm]

Hello, 

below image where CURR_MTH_EXP = TOTAL EXP(MeasureA) - PRIOR MONTH EXP (MeasureB)

2M in the card is the total exp for the past no of months in the table.

Is there a way I can change the total of 2M in the card to Average month exp based on table?

and of course, months could be days or hours.

Thank you

Zoey

[Anonymous]

Thank you Greg_Deckler and ryan_mayu

Hi, @zraopingm 

First you can create a date slicer as follows:

Then create a quick measure:

The results are as follows:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[ryan_mayu]

maybe you can try this

= averagex(values(CY_MONTH),  CURR_MTH_EXP)

[Greg_Deckler]

@zraopingm This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

[zraopingm]

Thank you, I am just looking for if there is a quick way to submarize by card with the total, or average on a range of data derived from a measure. 

Zoey