Counting number of repeaed IDs

[LINUS_MAASTOK]

Hello everyone! i need to make a report with the number of times that a user buy a product...
the report must be separated into ranges, and the number of IDs varies from 1 to 20 in the table.

im working on power bi; maybe i need to use a measure? i leave a img of my idea. THX nwn <3

https://imgur.com/a/jyNrkyh

 

[Sam_D_Ben]

Please check if this helps you.

Also you could do PIVOT.

Excel 2013/2016
	A	B
1	Values	Count
2	965570	7
3	965570	7
4	965570	7
5	965570	7
6	965570	7
7	965570	7
8	965570	7
9	965211	4
10	965211	4
11	965211	4
12	965211	4
13	964920	1
Sheet1

Cell Formulas
Range	Formula
B2	=COUNTIF($A$2:$A$13,A2)

 

[LINUS_MAASTOK]

that works in power BI? ... im new on it... i will try , thx

 

[sandy666]

im working on power bi

with PQ group with count and extract column/s if necessary