Apply 'Count' to result of 'Aggr'

[Luca1]

I want to use the results of the following table to create a KPI: 

The KPI I want to create is the 90 from the right column. In order to access 90, I need to apply 'Count(DISTINCT OrderID)' to the first row of the 'Aggr()'-result in the same expression. How can I achieve that? 

[vikasmahajan]

Hi,

Try this 

FirstSortedValue(DISTINCT Customer, Rank(Count(Distinct OrderID), 4, 1), Customer)

[Luca1]

Hey, your solution yields the following error:

 

[tresesco · Accepted solution]

Try something like (with reverse condition to get the false output):

Count(Distinct{<[customers$.CompanyName]={"=Count(Distinct OrderID)<=10"}>} OrderID)

[Luca1]

Your support is superb guys, thank you!