column value keeps changing

concatenate(
"0000",
COUNT(
FILTER(
"Purchase Item",
[Item]=[_THISROW].[Item]
)
)+1
)

when ever i delete older data and i update an active row , Because it has a count formula the  value keeps changing. How do i make sure the value does not change every time i update the row

0 1 54
1 REPLY 1

Top Labels in this Space