Dax CountRows

[ibuhary]

Hi All,

I have a dax model, where I identify new users marked as "1" in a field.
The new user identification appears only one time to those records which consists new users first time in the model.
e.g. for a given period the data as follows:
User A - 0
User A - 0
User A - 0
User B - 1
User B - 0
User A - 0
User A - 0
User A - 0
User B - 0
User A - 0
User C - 1
User C - 0

In the above data "User A" does not qualify as a new user as he was an old user from previous period. But users "B" & "C" are new users in the given period.
I want to create a measure which calculates "countrows" of new users in the given period.
Expected results:
zero for User A
3 for User B
2 for User C

Any help is appreciated.

[JeteMc]

I will be interested to see how/if this can be done using DAX.
In the meantime here is how it might be handled using a normal pivot table.
1. Add a column to the source data: =IF(B2=1,1,IFERROR(IF(VLOOKUP(A2,A$1:B1,2,0)=1,1,0),""))
2. Pull the field for the new column into the values area and summarize values by Sum
Let us know if you have any questions.

[ibuhary]

@JeteMc Thanks for your reply.
Unfortunately, I am unable to create a helper field in the database, its huge, and might slow down my model.
Let us see if anyone can come up a Dax measure for this.

[JeteMc]

As you already have a Dax model, according to post #1, it may help if you could attach a sample file to your post.
Information regarding attachments is in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.

[ibuhary]

I don't think it can add any value.
The subject calculation is withing the following three Fields:
User ID (A, B, C, etc)
NewUser (1, 0)
Date

[romperstomper]

You could use a measure like:

=VAR NewUsers = SELECTCOLUMNS(FILTER(Table1,Table1[New]=1),"User",Table1[User])
RETURN CALCULATE(COUNTROWS(Table1),NewUsers)

[ibuhary]

Thanks, that was so easy in the end