Find Max value of a measure by column header in matrix visual

[Anonymous]

Hi There,

I have a matrix visual that displays the WoW change (a measure) per marker selected as the column header (MarkerTable) by Year&Week (Date Table).  I want to identify the max WOWChange in each column of the visual.

These are the basic measures...I'm really using a bunch of SWITCH() for Currency/Unit conversion. 

AveragePrice =

AVERAGEX(

    KEEPFILTERS(VALUES(Date[Date Time])),

    CALCULATE(SUM(MarkerPrice_AllDates[Dollar/Unit_CAD]))

)

PW_AveragePrice=

Var CurrentWeek = SELECTEDVALUE(Date[WeekNumber])

Var CurrentYear = SELECTEDVALUE(Date[Year])

Var MaxWeekNumber=Calculate(MAX(Date[WeekNumber]),ALL(Date))

RETURN

AVERAGEX(FILTER( ALL(Date),

    IF(CurrentWeek = 1,

        Date[WeekNumber] = MaxWeekNumber && Date[Year] = CurrentYear -1,

        Date[WeekNumber] = CurrentWeek-1 && 'ate[Year] = CurrentYear)), [AveragePrice])

WoWChange =

AveragePrice-PW_AveragePrice

WoWChangeMAX??

[parry2k]

@Anonymous can you try this measure

Max Avg = 
MAXX ( ALL ( Table[Year and Week] ), [Your Measure] )

[Anonymous · Accepted solution]

I got it!  I was using the wrong date increment...silly me...

I used this measure in the conditional formatting as the field value.  Pretty in pink!

WoWChangeMax =

VAR MaxChange =

    MAXX ( ALLSELECTED ( 'Date'[Year & Week] ), [WoWChange] )

RETURN

    SWITCH(TRUE(), [WoWChange] = MaxChange, "#E61576"  )