Calculate how many suppliers have certain number of workers

[Kraw421]

Hi all,

I am very new to Power BI (mainly a Spotfire user) and i am totally stuck trying to convert my spotfire brain to Power BI. 

(Dummy example below of what i need to do).

I have a report that has one table "Workers", with columns "Employee ID" and "Supplier". 

I need to table that shows me how many workers each supplier has, but now i need to show how many suppliers have only 1 worker, 2 worker etc...

or even summarise the data in ranges, i.e. 100 suppliers have 1-5 workers, 80 have 6-15, 30 have 16-30....etc...

I would have done this in spotfire by summing the total employee ID over supplier. 

Employee ID	Supplier
1233545	Maxx CO
2354565	Maxx CO
2345665	Johnson PTY
5675678	Felix Sons
5656453	Maxx CO
3243565	Clara Ltd

Number of workers	Number of Suppliers
1	3
2	0
3	1

[ryan_mayu · Accepted solution]

@Kraw421 

pls see the attachment below

[Kraw421]

Thanks for this. How did you create the new table 2? 

Sorry i might need some step by step instructions on how you built it...

[ryan_mayu]

I use DAX to create the table

Table 2 = GENERATESERIES(1,max('Table'[Column]))

[Kraw421]

thank you! i managed to figure out your solution and it worked! thanks champ!!

[ryan_mayu]

you are welcome