Max value bar chart

[stephane_veriss]

Hello,

I have a bar chart (see below) for which:

- The dimension is G

- The measure is a count (ID_number)

I would like to display in a simple KPI the maximum value of the bar chart (39)

Could you help me writting the formula that will allow me to have the max value of the G dimension ?

Thank you in advance

Stephane

[sunny_talwar · Accepted solution]

Try this

Max(Aggr(Count(ID_number), G))

[stephane_veriss]

perfect thanks