Distinct value

[Anonymous]

I've an order table in which some of orders has been created in different time but on the same day:

Ordernr	Orderdate
order1	2020-11-23 10:20
order2	2020-11-23 10:27
order3	2020-11-23 10:39
order4	2020-11-24 14:29
order5	2020-11-24 14:37

In slicer it shows all dates with different time but I want to show only dates so when I select that date all orders would be listed in table. In this example instead of showing all dates in slicer I want to show only two dates:

2020-11-23

2020-11-24

If I select 2020-11-23 in slicer , then show order1,order2, and order3 in report.

[amitchandak · Accepted solution]

@Anonymous , Create a date column without timestamp and use that.

Date = [Orderdate].date
or
Date = date(year([Orderdate]),month([Orderdate]),day([Orderdate]))

You can also use distinctcount(Table[Date])

or

distinctcount(Table[Ordernr]) measures in visual