Forum Discussion
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 | 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?
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
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.
4 Replies
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
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.