Forum Discussion

davidi4524's avatar
davidi4524
Helper III
8 years ago
Solved

counting records per user

hi, i have a table that contain the fo,owing colums:   name           date jonthan       19/11/2017 jonthan       20/11/2017 josef             20/11/2017 omar             20/11/2017 jonthan   ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi davidi4524,

     

    Look at your original question carefully - COUNT is exactly what you wanted.  Anyways, for your changed question now, try this

     

    =DISTINCTCOUNT(Data[Date])

  • Anonymous's avatar
    Anonymous
    8 years ago

    If you want a distinct count for my solution, simply select 'Distinct Count' from the dropdown instead of 'Count'.

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

This should not be a calculated column but a measure.  Drag the Name, create a date slicer  and make any selection.  Then use this measure

 

=COUNTROWS(Data)

 

Hope this helps.

  • davidi4524's avatar
    davidi4524
    Helper III
    8 years ago

    sorry, i'm new to the dax language.  what execly the syntax to make it?

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      8 years ago

      Hi davidi4524,

       

      Have you tried the solution provided above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

       

      If you still have any question on this issue, feel free to post here. :smileyhappy:

       

      Regards