Help with Max value over dimension

[josemaria_cabre]

Hi,
I'm having trouble finding month with max value from this set of data:

I'm looking for an expression that returns 8.28 M, but with this expression:

Max( total <[IssueDate.autoCalendar.Month]> aggr( $(v.TotalCost), [IssueDate.autoCalendar.Month])) 

I'm getting 12.88 M, (which is the sum of 8.28 M + 4.6 M ...)

How should I modify this expression to return max value from all months, but without aggregating ?

Thanks in advance for your help,
Jose

[sunny_talwar · Accepted solution]

What is the second dimension in your chart? Try this

Max(Aggr($(v.TotalCost), [IssueDate.autoCalendar.Month], Dimension2)) 

[josemaria_cabre]

Second dimension is [IssueDate.autoCalendar.Year], and now it works with:

Max(Aggr($(v.TotalCost), [IssueDate.autoCalendar.Month], [IssueDate.autoCalendar.Year]))

Thanks a lot for your help Sunny!