Maximum Value as KPI

[Anonymous]

Hi,

In my report, I am trying to create a measure that would express the column content that is associated with the highest value.

Regarding the dataset, it looks like the following:

Name	Value
A	7
B	98
C	67
D	29

Therefore, I want the card visual with the measure in it to show the name (here, B) which has the highest value, out of all four.

Do you have suggestions on how to do that? 

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below.

The Highest Value Name =
CALCULATE (
MAX ( 'Table'[Name] ),
FILTER ( 'Table', 'Table'[Value] = MAXX ( 'Table', 'Table'[Value] ) )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ；

you could create a measure as follows:

Maximum KPI = CALCULATE(MAX('Table'[Name]),
TOPN (
1,
'Table',
'Table'[Value], DESC
))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Do you have any suggestion what to do in case two Names, lets say A & B have the same value, and their value is the higest of all?

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below.

The Highest Value Name =
CALCULATE (
MAX ( 'Table'[Name] ),
FILTER ( 'Table', 'Table'[Value] = MAXX ( 'Table', 'Table'[Value] ) )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]

Do you have any suggestion what to do in case two Names, lets say A & B have the same value, and their value is the higest of all?