total users daily count by user Ids

Question

Hi,&nbsp;So this is my column&nbsp;UserIds&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; More ColumnsxjhbdckjbfdjhbadDSKbakdhvbakjdsbJDcjhvbakjsdb&nbsp;I have new users coming in daily...How do I count distinct users each day and make a column for running/ cumulative total.&nbsp;something like-&nbsp;if total users on 1st 2nd 3rd 4th and 5th dates were 5, 10 , 15, 20, 25then the column should say&nbsp;Dates&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total Users1st&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 52nd&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;153rd&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 304th&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50so on&nbsp;The problem is the user id are text data type so have not been able to count and apply calculate formula to it.Thanks&nbsp;

v-piga-msft · Answer

Hi&nbsp;Ankit_1987,&nbsp;From your description, you may have a misunderstand of measure and calculated column. In this case, you should create a measure not a calculated column.&nbsp;You could refer to the steps of creating a measure:&nbsp;Click Modeling ——New Measure&nbsp;&nbsp; &nbsp;&nbsp;2.&nbsp; Type in the dax function:&nbsp;&nbsp;&nbsp; &nbsp; 3. &nbsp; You could rename the measure as you want.&nbsp;If it still doesn’t work, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it?&nbsp;You can upload it to OneDrive or Dropbox and post&nbsp;the link here. Do mask sensitive data before uploading.)&nbsp;Best Regards,Cherry &nbsp;

v-piga-msft · Answer

Hi Ankit_1987,&nbsp;From your description, I try to reproduce the scenario as yours. If you want to make a column for running/ cumulative total, you could create the measure like this:total User = COUNTAX(FILTER(ALLSELECTED(User),User[Date]&lt;=MAX(User[Date])),User[UserId])&nbsp;This visual you could refer to:&nbsp;&nbsp;For the details, you could refer to my test pbix file here.&nbsp;Hope it can help you!&nbsp;Best Regards,Cherry &nbsp;

ankit_1987 · Answer

Hi Cherry,Thanks for the revert, I thought it helped. bUt here what I got...&nbsp;I replicated what you did- These are two column in question..the list is long...&nbsp;after adding the column you mentioned--I got this--&nbsp;Not what I was expecting...Also I noticed in your pbix file calculated column are shown as measure(like a calculator)..mine shows something else

Forum Discussion

total users daily count by user Ids

3 Replies

Related content

Storage increasing daily

Community User Group Experience

Fabric & Azure Data User Group Program Requirements & Benefits

SQDCP Daily Dashboard

Reset running total daily