Count of sellers in specific date (simple?)

[jussiwaisto]

Hi,

I want to count how many sellers do i have in specific date using date slider.

I have this kind of table and I would like to know how many sellers i had in 04/01/2019? Answer should be 2 (I had two sellers: Name4 and Name1)

What kind of measure I need to make?

[jussiwaisto]

Thanks for replyin, but didn't work. It gives about 900rows, should give just few.

[jussiwaisto]

Sorry, it works! Thanks!

[Anonymous · Accepted solution]

Try this Measure

SellerCount = DISTINCTCOUNT(Table[SellerName])

and use the date in a slicer