Highlight the max value in a chart

[Mumin192]

Hello

I'm trying to highlight the maximum count by age in my data

I used this measure

Max Value =

var allthedatesused = ALLSELECTED(prf[Age])

var themaxvalue = MAXX(allthedatesused, [TotalPRF])

return

IF([TotalPRF] = themaxvalue,"#000000")

it worked, but I had to create a table with all age ranges but sorted by range, but when I link the sort to the age table, it doesn't work

Max Value2 =

var themaxvalue = MAXX(ALL(age[Age]), [TotalPRF])

return

IF([TotalPRF] = themaxvalue,"#000000")

The first chart is using age from the original table, while the 2nd chart is using the ages table

Any idea how to fix the issue with the 2nd chart?

Here's a link for the file

https://drive.google.com/file/d/13S9q0S0oWovbeIbM0lwFLfDgsJFPCsz3/view?usp=sharing

Thanks

[Greg_Deckler · Accepted solution]

@Mumin192 Here is one possible fix, updated PBIX is attached.

Max Value2 = 
var __table = 
    ADDCOLUMNS(
        SELECTCOLUMNS(ALLSELECTED(age[Age]),"AgeAge",[Age]),
        "__TotalPRF",COUNTROWS(FILTER(ALL('PRF'),'PRF'[Age] = [AgeAge]))
    )
var themaxvalue = MAXX(__table, [__TotalPRF])
return
IF([TotalPRF] = themaxvalue,"#000000")