How to count the number of repeated rows in story table

[tara_shi]

Hello there! ~

I face issue as below, if someone can help me here.

My original story table contains first 3 columns similar as below table, as there are repeated "category", so I would like to add a new column at last to count the repeated row number for the same "category", as in story table, there is no "count if" formular, and i tried create new measure with "aggregation" count, it still doesn't work.

BTW: I cant have calculation in data model, as this is live data, it doesn't allow me to edit.

Thank you very much for the help, and if I didn't make myself clear, I can explain more on this.

Category	Sub-category	amount of sub-category	count of category
fruits	peach	2	3
fruits	watermelon	3	3
fruits	apples	5	3
books	magazine	1	2
books	children book	4	2
Snacks	chips	3	4
Snacks	candy	6	4
Snacks	bread	2	4
Snacks	biscuits	1	4

[N1kh1l]

@tara_shi 

May be you could try COUNTDIMENSION on category  in story calculation with calculation Type aggregation.

Nikhil

[tara_shi]

Thanks, I tried this, I think the caculation itself has no issue, the issue was found by our IT guy in model.