Forum Discussion

Andre-SiS's avatar
Andre-SiS
Frequent Visitor
2 years ago
Solved

Distinct count per day

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. 

Need Help
  • miTutorials's avatar
    miTutorials
    2 years ago

    Please try the below measure.

     

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

     

    Regards

    Ismail

     

2 Replies

  • miTutorials's avatar
    miTutorials
    Super User
    2 years ago

    Please try the below measure.

     

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

     

    Regards

    Ismail