Countifs for each specific value

[Anonymous]

Dear friends

how can i create calculated column that shown no. of rows that contain values or text in column for each specific reference number

Example.

Ref. number	Values	calculate column
1111	a	2
1111	b	2
1111
2222	c	1
2222
3333	b	1
3333

thanks in advance for any suggestions

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

countx(filter(Table, [Ref. number] =earlier([Ref. number]) && not(isblank([Values]))),[Values])

[Anonymous]

thank you so much!! its works @amitchandak