Forum Discussion
counting records per user
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])
If you want a distinct count for my solution, simply select 'Distinct Count' from the dropdown instead of 'Count'.
If you want simply display the table, you can do that with just a couple clicks using the Table visual. Just drag the 'Name' column onto the table twice. Click the drop down arrow and select 'Count'. Then, create a filter using your Date column. Be sure that it's formatted as a date or date/time or you won't see the slider, you'll see check boxes.
If you want to create a brand new table...
- Enter the Query Editor
- Right-click the table and select 'Duplicate'
- With the new table selected, click 'Group By' from the 'Transform' section of the home ribbon
- Choose to group by your Name column
- Choose the Operation 'Count Rows'
- Click 'OK'
ok but i need to count distinct the numbers of the records per the username between dates. this solusion is only make a subtotal per username
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])