Need help with cumulative total of each row and add +1 if value repeats

[n2p2gupta]

I am learning DAX and need help to create DAX formula to calculate "Column2" by looking at each row in "Column1".  If value repeats in "Column1" I would like to add +1 to the existing value in "Column2".  Thanks for your help in advance.

[Eric_Zhang · Accepted solution]

---

@n2p2gupta wrote:

I am learning DAX and need help to create DAX formula to calculate "Column2" by looking at each row in "Column1".  If value repeats in "Column1" I would like to add +1 to the existing value in "Column2".  Thanks for your help in advance.

---

@n2p2gupta

See the solution I posted in your another thread.