DAX - Count of days with target achieved

[kostask]

Hi, guys.

For the following 1st table, I'm struggling to calculate the measure (DaysWithSales>1000) that gives the number of distinct days that each products' sales, are in total (Sum of lines' Sales) over 1000 (2nd table).

Thanx in Advance!!

Kostas

[kostask]

This works perfectly @amitchandak .

Another great solution of you!

Thanx !

[amitchandak · Accepted solution]

@kostask , display this measure with product in a visual

Countx(filter(Summarize(Table, Table[product], table[Date], "_sales", sum(Table[Sales])), [_sales]>1000),[product])