Forum Discussion

EVEAdmin's avatar
EVEAdmin
Post Patron
6 years ago
Solved

Count Distinct Values By Column and by Date

Hi all   I have a table similar to the following The table is already link to a DateTable DBName is the name of the database providing the data CustomerID is the ID of each customer in tha...
Need Help
  • RakeshNag's avatar
    RakeshNag
    6 years ago

    Hi,

     

    Please find the below DAX measure solution.

    DistinctCountOfCustomer = CALCULATE(DISTINCTCOUNT(DB_Table[CustomerID]),VALUES(Date_Table[Year]))

    It is working fine. Please check and advise if it also works as per you.

     

     

     

     

    Thanks,

    Rakesh

  • amitchandak's avatar
    amitchandak
    6 years ago

    If you need across the used combined column. If you need by DB and By year. Then you can take distinct of customer ID. But if you are using DBname in your visual then the combined one will also work.

RakeshNag's avatar
RakeshNag
New Member
6 years ago

Hi,

 

Please find the below DAX measure solution.

DistinctCountOfCustomer = CALCULATE(DISTINCTCOUNT(DB_Table[CustomerID]),VALUES(Date_Table[Year]))

It is working fine. Please check and advise if it also works as per you.

 

 

 

 

Thanks,

Rakesh

  • EVEAdmin's avatar
    EVEAdmin
    Post Patron
    6 years ago

    RakeshNag thank you.

    That returns unique customers by Year. I need unique customers by DBName by year 

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      If you need across the used combined column. If you need by DB and By year. Then you can take distinct of customer ID. But if you are using DBname in your visual then the combined one will also work.