how to get a max value from a list of compared values?

[Anonymous]

I'm creating a supplier scorecard and needed to compare supplier rating values to the population rating values based on buckets (Cost, Performance, Knowledge, Recommendation). The process is twofold, needing to find 1) which values in the sample are greater than the values in the population group and return that group of values, 2) which is the max of those values in the sample group that is greater than the population group. In the picture, for Supplier1, Cost, PErformance, and Recommendation are larger than the population, and the largest fo those 3 is Cost. The end goal here is to use these numbers to put into an advanced card.

[v-juanli-msft]

Hi @Anonymous 

Finally, you want to get a card visual to display the max value, right?

For example, 

for Supplier1, Cost, PErformance, and Recommendation are larger than the population, and the largest for those 3 is Cost,

finally 20 for Supplier1 Cost displays on the card visual.

Do you have a slicer to select Supplier1, Supplier2....

Does the max value compare among buckets (Cost, Performance, Knowledge, Recommendation) for each Supplier?

Or for different Suppliers?

Best Regards

Maggie