Forum Discussion
davidi4524
8 years agoHelper III
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 ...
- 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])
- Anonymous8 years ago
If you want a distinct count for my solution, simply select 'Distinct Count' from the dropdown instead of 'Count'.
davidi4524
8 years agoHelper III
sorry, i'm new to the dax language. what execly the syntax to make it?
v-ljerr-msft
8 years agoMicrosoft Employee
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