Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Maximum Value as KPI

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...
Need Help
Show and Tell
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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's avatar
    v-yalanwu-msft
    5 years ago

    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.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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?