new column with the count how many times it is repeated

[paulohm]

ID_1	DATE	ID_USER	DATE	QNT
1	12/11/2019	150	10/05/2019	186
2	06/03/2020	184	02/01/2020	64
3	28/02/2020	187	01/12/2019	89
4	15/05/2020	187	01/12/2019	166
5	04/06/2020	187	01/12/2019	186
6	17/07/2019	376	12/05/2019	66
7	21/08/2019	376	12/05/2019	101
8	23/08/2019	376	12/05/2019	103
9	20/09/2019	376	12/05/2019	131
10	25/10/2019	376	12/05/2019	166
11	20/02/2020	376	12/05/2019	284
12	20/02/2020	376	12/05/2019	284

I need a new column that counts how many times the ID_USER was repeated, no problem, the data displays more than once

[harshnathani · Accepted solution]

HI @paulohm ,

Create a Column

Column = CALCULATE(Count('Table'[ID_USER]),ALLExcept('Table','Table'[ID_USER]))

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[harshnathani · Accepted solution]

HI @paulohm ,

Create a Column

Column = CALCULATE(Count('Table'[ID_USER]),ALLExcept('Table','Table'[ID_USER]))

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[paulohm]

@harshnathani 
Thanks for the help above, but I need one more favor.

I now need to know the number of users who showed up more than 6 times, and that the QNT was less than 140.

I need to know the number of users without repeating

[harshnathani · Accepted solution]

Hi @paulohm ,

Based on Column created, create a new measure.

CC of Cust =

CALCULATE(COUNT(Table14[QNT]),FILTER(Table14, Table14[Column]>6 && Table14[QNT] <140))

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[paulohm]

THANK YOU FRIEND