Distinct count per day

[Andre-SiS]

I have a table that shows sales data (SalesDashboard). 

I want to count the number of sales per day. 

I want to do this by count distinct values per day - since each sale has a distinct order number. 

I've gotten this far, but how can I count it per day instead of the overall sum?

Number of Sales Per Day =
CALCULATE (
DISTINCTCOUNT(SalesDashboard[Entry_No],
))​

In my data model, I have a seperate DateTable so that all days are existing. 

In my table SalesDashboard, I also have a date field that's related to the DateTable. 

I have looked at other posts, but I can't seem to get it to work. 

[Andre-SiS]

Works like a charm - thank you!

[miTutorials · Accepted solution]

Please try the below measure.

DistinctCountByDate = 
CALCULATE(
    SUMX(
        VALUES('YourDataTable'[Date]),
        CALCULATE(
            DISTINCTCOUNT('YourDataTable'[Order ID])
        )
    )
)

Regards

Ismail