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 numbe...
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

     

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