Count outlets which have sales > x and other condition?

[nguyenviethung]

Hi all,

Can anyone help me with this case as I found no likewise situation on this forum:

I want to count no. of outlet with total sales-out >23 as below:

Count({$<Sales={">23"}>} DISTINCT [Outlet ID])

However, Sales are measured by = Sum({$<[Order status]={"Approved"}>}[Sales-out]), which means only approved orders are count. (I have different order status, not only Approved and want to load all status)

Then how can i combine those into 1 expression to count qty of outlets satisfying those conditions?

Thank you.

[sunny_talwar · Accepted solution]

May be this

Count({$<[Outlet ID] = {"=Sum({$<[Order status]={'Approved'}>} [Sales-out]) > 23"}>} DISTINCT [Outlet ID])

[nguyenviethung]

Thanks Sunny. That's great. You made my day.