Max of aggregated measure by month year

[Russ]

Looking for the most straightforward way to calculate the max of an aggregated measure (Measure A) added to a table column by row MonthYear? MonthYear is from a calendar table, connected to the fact table by a one to many relationship on date.

Something like the following -

[v-xicai]

Hi @Russ ,

You may create measure like DAX below.

Max Measure A= CALCULATE(MAXX('Fact Table', [Measure A]), FILTER(ALLSELECTED(Calendar), YEAR(Calendar[Date])=YEAR(MAX(Calendar[Date]))))

Best Regards,

Amy 

Community Support Team _ Amy

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

[harshnathani]

@Russ ,

You can also try,

Measure = CALCULATE (MAX(Table[MeasureA]),ALL(Table)) 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[amitchandak]

@Russ , try like

calculate(maxx(values(Table[MonthYear]),[Measure]),all(Table))

[Russ]

Many thanks, @amitchandak  @harshnathani  @v-xicai , for the replies. 

@amitchandak , solution works fine.

 @harshnathani, could not get your solution to work as Max function will only accept table column, not a measure.

@v-xicai , solution gives a range of results, depending on row context.

[v-xicai]

Hi @Russ ,

Yes, the MAX function will only accept table column, while the measure can be used in MAXX function instead of MAX function.

Best Regards,

Amy