COUNT or DISTINCTCOUNT?

[jellis1971]

What is the difference between COUNT and DISTINCTCOUNT?

Is one preferable?

[TomMartens]

Hey @jellis1971 ,

both functions do not answer the same question, for this reason none is preferable over the other.

Here you will an article about COUNT: COUNT – DAX Guide
Here you will find an article about DISTINCTCOUNT: DISTINCTCOUNT - DAX Guide

If you have a fact table containing three orders, from 2 different customers (2 orders from customer a, and 1 order from customer b).

COUNT( 'orders'[customer]) will return 3
DISTINCTCOUNT( 'orders'[customer]) will return 2

Hopefully, this provides what you are looking for.

Regards,

Tom

[ribisht17]

@jellis1971 

https://docs.microsoft.com/en-us/dax/distinctcount-function-dax

https://docs.microsoft.com/en-us/dax/count-function-dax

I ordered Soft-Drink Pepsi three times

So, distinct count of Softdrink will be 1 (Only one type of Soft-Drink)

But count of my order will be 3 because I ordered 3 times

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[MahyarTF · Accepted solution]

Hi,

If there is the same record, the count is counted as a one, but in DitinctCount the same columns are considered as one record (same as Distinct in Sql) :

Appreciate your Kudos