Displaying MAX of Column when Filtering Date

[Anonymous]

Hi, 

Is there a way to display the Max value of a column on a dashboard when there exists a Year filter?

DATE_OPENED	TTC
4/8/2020 0:00	0
4/7/2020 0:00	0
4/7/2020 0:00	0
4/7/2020 0:00	0
4/4/2020 0:00	4
4/4/2020 0:00	5
4/6/2020 0:00	0
4/2/2020 0:00	0
4/2/2020 0:00	4
4/1/2020 0:00	8
4/3/2020 0:00	0
4/6/2020 0:00	0

For example, in the dataset above, if the year 2020 was selected on my Chicklet filter, I would want the Card output to say "8"

Please let me know if this question does not make sense

Thank you!
Sarah

[az38]

Hi @Anonymous 

in verycommon case just

= CALCULATE(MAX('Table'[TTC]))

will give desired result

[Anonymous]

@az38 , This gives the Max of the whole column, but I want it to display the Max of multiple years... so for example if the Max is 8 in 2020, I want all 2020 dates to display "8" but if the max is 13 in 2019, I would want it to display "13"

thank you!
Sarah

[az38 · Accepted solution]

@Anonymous 

smth like

= CALCULATE(MAX('Table'[TTC]), ALLEXCEPT(Table, Table[DATE_OPENED].[Year]))