max date next to a measure aggregate on a matrix

[Fro88er]

I am trying to add the last or Max Date the 300k Club Count was recorded at each Recruiter and YearMonth.  When I try and put the YearMonth in the values box in the Matrix and select latest I get the last date that Recruiter had activity, and not when his Total Revenue was above 300k, per YearMonth.

Thanks in advence for looking at this.

300K Club Count =

IF(

HASONEFILTER(DimCalendar[YearMonth]),

IF([Total Revenue] >= 300000,

1,0),

CALCULATE(

COUNTROWS(DISTINCT(DimCalendar[YearMonth])),

FILTER(DimCalendar, CALCULATE([Total Revenue],

ALLEXCEPT(DimCalendar, DimCalendar[YearMonth])) >= 300000

)))

[mahoneypat · Accepted solution]

Please try this measure to get your desired result:

Latest 300K YearMonth =
VAR __300kmos =
    FILTER ( ALL ( 'Date'[YearMonth] ), [Total Revenue] > 300000 )
RETURN
    MAXX ( __300kmos, 'Date'[YearMonth] )

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Fro88er]

This worked perfectly.  Thank you so much!