topic Apply 'Count' to result of 'Aggr' in App Development

Apply 'Count' to result of 'Aggr'

Luca1 — Fri, 31 Dec 2021 00:00:37 GMT

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?

Re: Apply 'Count' to result of 'Aggr'

vikasmahajan — Fri, 31 Dec 2021 08:25:00 GMT

Hi,

Try this

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

Re: Apply 'Count' to result of 'Aggr'

Luca1 — Fri, 31 Dec 2021 08:59:37 GMT

Hey, your solution yields the following error:

Re: Apply 'Count' to result of 'Aggr'

tresB — Fri, 31 Dec 2021 09:41:39 GMT

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

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

Re: Apply 'Count' to result of 'Aggr'

Luca1 — Fri, 31 Dec 2021 09:48:48 GMT

Your support is superb guys, thank you!