Return 1 row per month depending on the MAX per month of a column.

[heberpower]

My data set looks like this:

This is my desired results but I have been struggling with this for weeks now.  Any help is appreciated!

I need to retrieve 1 row for each month where the "Peak" is the MAX during that month.  Like this:

Desired Results:

[Shishir22 · Accepted solution]

Hello @heberpower ,

Create below measure and use Measure = 1 as a visual level filter.

MeasureFlag = 
var _Month= SELECTEDVALUE(DimDate[Month])
var _Year= SELECTEDVALUE(DimDate[Year])
Return
if(MAX(PeakTable[Peak])=CALCULATE(MAX(PeakTable[Peak]),FILTER(ALL(DimDate),DimDate[Month]=_Month && DimDate[Year]=_Year)),1,BLANK())

Screenshot:

If this fulfils your requirement please mark it as a solution. Kudos are also welcomed!

Thanks!

[heberpower]

Worked like a charm!  Thanks!