Find the max value by month

Question

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 Answer

Anonymous try this measure
&nbsp;
Max Pass Count = 
MAXX( VALUES( Table[Month] ), [Pass] )

Forum Discussion