Count Records in powerpivot

[qaz123434]

hi i have a list of data im trying to create a calculated column to count the records like this

e.g

dog 1
dog 2
dog 3
cat 1
cat 2
mouse 1
cow 1
cow 2
cow 3
cow 4

 

[mole999]

matching on the number of animals or would if they are in A
=countif(A1:A10,"dog")
=countif(A1:A10,"cat")
=countif(A1:A10,"mouse")
=countif(A1:A10,"cow")

?

 

[qaz123434]

Hi I need a dax formula for a calculated column in powerpivot

 

[scottsen]

I'm not super sure what you are asking, nor super sure why a calculated column (vs a measure / calculated field).

Your choices are mostly COUNTROWS() or COUNTA(), but I think you are asking something crazier (this is the first cow in my table, this is the 2nd cow in my table), which actually sounds somewhat challenging.

I'm kinda curious what your ACTUAL scenario is

 

[Norah]

If you really want to do this as a calculated column (rather than a measure), you will probably want to use the EARLIER() formula.
Writing a Subtotal Calc Column, AKA The Simplest Use of the Earlier() Function « PowerPivotPro