Find the max value by month

[Anonymous]

I have a data table showing audit date and result. I have grouped table to count the passes and fails. 

[audit date] - any date from 2017 to date

[result] - can be 'pass' or 'fail'

[count] - 1

I have a measure counting the passes:

Pass = CALCULATE(SUM('Loaders&Assessors Results'[Count]),FILTER('Loaders&Assessors Results','Loaders&Assessors Results'[Result]="Pass"))

I want to create a measure that shows the maximum pass count, split by month. So if the total pass by month is as follows:

Jan 100

Feb 150

Mar 200

Apr 75

The Measure, if it were displayed in isolation such as a Card, would show 200.  Until May comes in at 250 then it would change to 250.

I want this measure for a gauge visualisation. 

[parry2k · Accepted solution]

@Anonymous try this measure

Max Pass Count = 
MAXX( VALUES( Table[Month] ), [Pass] )