new column / number of observations per group

[Anonymous]

How to create a new column and show the nomber of obs per group

Table A

obs  group value numberOfOBsPerGroup.

1  A   100    3

2  A    150    3

3  A    125    3

4  B    74      2

5  B    60     2

[Anonymous · Accepted solution]

Hi @Anonymous ,

Follow these steps:

1- Go to Modeling and hit on New column

2. A new column will be added in the field area like this:

3. Click on that and add this formula here

My output:

Let me know for any if this works.

Thanks,

Tejaswi

[az38]

hi @Anonymous 

try a simple measure if i understand you correct

Measure = calculate(count('Table'[obs]),ALLEXCEPT('Table','Table'[group]))

will it be ok for you?

do not hesitate to give a kudo to useful posts and mark solutions as solution