Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |