DISTINCTCOUNT with sum filter

[tomekp0]

I have simple sales data, each row is equal to one SKU sold, sample: 

Date	Client	SKU	Price	Seller
01.09.2022	AAA	Item1	99	Seller1
01.09.2022	AAA	Item2	109	Seller1
02.09.2022	BBB	Item1	99	Seller2

How to count clinents that orderder above certaint treshold (for example 5000) in each time perion?

Ive alcready done filtering by sellers and by dates, but i have problem with DISTINCTCOUNT funcion.

My atteptes: 

1) 

Clients1 = CALCULATE(DISTINCTCOUNT('sales'[Client]), 'sales'[Price] > 5000)

2)

Created new measure: 

sum_sales = sum(sales[Price])

And: 

Clients2 = CALCULATE(

DISTINCTCOUNT(sales[Client]),

FILTER('sales', [sum_sales] > 5000)

)

Everytime i've got same resoults. Filter working per row, and calculate only products that exceed, 5000 , not  total sum of orders for each period

[Anonymous · Accepted solution]

Hi @tomekp0

A calculated column is an extension of a table that’s evaluated for each row . A calculated measure is not treated the same as any other table column. Unlike a calculated column, measures are evaluated on the fly with every change in context. 

So in your DAX , if you want to get the total sum of orders for each period , you can create a calculated to sum the total , then create a measure to judge with 5000 .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.