Get Axis Reference of Highest Value in Card

[Redacted_VAR]

hi there,

I'm trying to achieve something that feels simple, but im really struggling.

I have a graph, in which totals the orders vs fruit, and i want a card that shows the fruit with the most orders (where # of orders is a measure)

Fruit	# of Orders
Apples	10
Oranges	7
Pears	4

now using Maxx(Values(Shopping[Fruit]),[#ofOrders])) gets me the correct number of orders, but shows as "10" instead of "Apples".

all i want to do is swap these values for each different basket. any help would be appreciated!

[Redacted_VAR · Accepted solution]

Hey @jgeddes,

no need, with a slight amendment to your code I managed to find the solution:

Max Fruit = 
var _maxValue =
MAXX(Values(Shopping[Fruit]),[#ofOrders]))
Return
CALCULATE(
MIN(Shopping[Fruit]),
FILTER(Values(Shopping[Fruit]), [#ofOrders] = _maxValue)
)

 thanks so much for your help!

[jgeddes]

Something like the following might work for you...

Max Fruit = 
var _maxValue =
MAXX(Values(Shopping[Fruit]),[#ofOrders]))
Return
CALCULATE(
MIN(Shopping[Fruit]),
FILTER(Shopping, [#ofOrders] = _maxValue)
)

[Redacted_VAR]

Hey @jgeddes 

thanks for the suggestion, but that just returns a blank value, not the name of the fruit. i've checked to make sure i copied it across correctly. 

[jgeddes]

If you can share some sample data or dummy data that illustrates how your model is set up I can come up with a working solution for you.