New column to count number of instances in same table

[AP23]

Hi,

Hope someone can help with the following please:

I have the below TableA:

Person_ID	SessionCategory
11	Short Day
22	Full Day
11	Full Day
33	AM

I want to add a column to this table which shows the number of rows which contain the same Person_ID, such as the below:

Person_ID	SessionCategory	RepeatedID
11	Short Day	2
22	Full Day	1
11	Full Day	2
33	AM	1

I don't want to remove any rows at this stage, as I need to use the above to create two other tables filtered on a) Person_IDs showing just once, and b) Person_IDs that show 2 or more times.

Please can you advise how I can achieve this?

I have tried the following but I am receiving an error stating "The function COUNTX cannot work with values of type Boolean". (I have the column set to Data Type "Whole number".)

RepeatID =

var Test =

        TableA[Person_ID]

RETURN

        COUNTX(TableA, TableA[Person_ID] = Test)

Many thanks. 

[bhanu_gautam]

Thanks @Ritaf1983 this works

[Ritaf1983]

@bhanu_gautam 
Glad to help 🙂

[Ritaf1983 · Accepted solution]

Hi @AP23 
Please add a calculated column with the dax formula = 

repats = CALCULATE(count('Table'[Person_ID]),ALLEXCEPT('Table','Table'[Person_ID]))

the pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly