Top customers for a specific product

[Jeremy_F]

How can I get the top customer by number of orders or profit for a specific product A?

So, when I open the detail of Product A, one virtual column shows the name of the best customer for that product, and same applies to all products B, C etc

[LeventK · Accepted solution]

@Jeremy_F
Something like this might help:

TOP(
  ORDERBY(
    FILTER("Customers",
		[ProductA]=[_THISROW].[ProductA]
    ),
    [Orders], TRUE
  ),
  1
)

[Steve]

Or use INDEX() to get the single value instead of TOP() to get a list of one.

[LeventK]

@Jeremy_F
As @Steve proposed, you can also use this expression as well:

INDEX(
  ORDERBY(
    FILTER("Customers",
		[ProductA]=[_THISROW].[ProductA]
    ),
    [Orders], TRUE
  ),
  1
)