Solved: Count of sellers in specific date (simple?)

jussiwaisto · ‎07-01-2019

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?

Anonymous · ‎07-01-2019

Try this Measure

SellerCount = DISTINCTCOUNT(Table[SellerName])

and use the date in a slicer

jussiwaisto · ‎07-01-2019

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

jussiwaisto · ‎07-01-2019

Sorry, it works! Thanks!

Anonymous · ‎07-01-2019

Try this Measure

SellerCount = DISTINCTCOUNT(Table[SellerName])

and use the date in a slicer

Count of sellers in specific date (simple?)