Find categorical value based on maximum value of corresponding metric

[Anonymous]

I'm comparing industry benchmark data. For each industry, I have values for different aspects of their operations. I can then show how one industry compares with another. For example:

Remote workforce

Retail: 25%

Government: 33%

For a given metric, I'd like to also display the industry with the maximum value for that metric, along with the value. I want to do this using an explicit measure so I can use the current filter context.

I have a measure that correctly finds the maximum value:

Overall Maximum = 
CALCULATE(MAX('fact_metrics'[Value]), ALL('dim_Industry'[Industry]))

How do I find and display the industry that corresponds to the value of Overall Maximum for a given attribute (e.g., median, 25th percentile, 75th percentile)?

The metrics table looks like this: 

Metric Category	Metric	Industry	Attribute	Value
Go to market	New product introduction	Financial Services	Median	10.5
Go to market	New product introduction	Financial Services	75th Percentile	15
Go to market	New product introduction	Financial Services	25th Percentile	25
Operational excellence	Use of data & analytics	Consumer Products	Median	10
Operational excellence	Use of data & analytics	Consumer Products	25th Percentile	8.5
Operational excellence	Use of data & analytics	Consumer Products	75th Percentile	20
Ways of working	Process automation	Consumer Products	25th Percentile	2
Ways of working	Process automation	Consumer Products	Median	5
Ways of working	Process automation	Consumer Products	75th Percentile	14.25
Ways of working	Work-From-Home	Financial Services	Median	63.5
Ways of working	Work-From-Home	Financial Services	75th Percentile	90
Ways of working	Digital Enablement	Manufacturing	Median	10
Ways of working	Digital Enablement	Manufacturing	25th Percentile	5
Ways of working	Digital Enablement	Manufacturing	75th Percentile	19.25

[lbendlin]

Your sample data is insufficient for percentile calculations. Please provide statistically significant samples.

[Anonymous]

@lbendlin I don't have the raw data, only the quartile values.

That said, I'm looking for the Industry(s) that correspond to the maximum value of the Median attribute.
For example, for the Metric "Work-From-Home", which Industry has the highest Median value?

Does that make sense?

I was trying to create a TOPN or possibly RANKX measure, but I haven't gotten it to work.

[lbendlin]

I don't think that's the right data or the right approach.  I hope someone else can help you further.

[Anonymous]

I can appreciate that my approach is incorrect. But how am I supposed to reply when you say it's not the right data? It's the data I have. You must live in a very rarified world if you can always get access to the data you want.

[lbendlin]

I am trying to protect you from making decisions based on insufficient data. I am sure you are familiar with concepts like statistical significance.  If this is the data you have then you should not try to make decisions from it.

[Anonymous]

You don't know me or my data. Your condescension is not appreciated.