Forum Discussion
Counting Units Per Company
Good Day! I have a live excel document that shows how many units were taken per company, with each company divided in to multiple foremans. All I want power bi to do is display how many 'pump & m...
ryan_mayu
Super User
Super Useryou can directly copy paste the data in the reply like below
| column | column2 |
| a | 1 |
| b | 2 |
| c | 3 |
| Company | Contact | 4 Gas | Pump&Monitor | Total Units |
| Acuren | Rob Arsenault | 22 | 2 | 24 |
| Cart | Darren | 8 | 10 | 18 |
| Cart | Bev | 6 | 11 | 17 |
| Clean Harbors | Doug | 28 | 6 | 34 |
| Clean Harbors | Matt | 10 | 5 | 15 |
| Edmonton Ex | Jeff | 8 | 4 | 12 |
| Edmonton Ex | Alanna | 6 | 4 | 10 |
| Edmonton Ex | Greg | 5 | 2 | 7 |
| Melloy | Jerry | 3 | 2 | 5 |
| Melloy | Jason | 32 | 6 | 38 |
What I would like is to be able to count how many '4 Gas' and 'Pump' and Monitors are issued per 'Company'. In a Table Visual like below:
| Company | 4 Gas | Pump&Monitor | Total |
| Acuren | 22 | 2 | 24 |
| Cart | 14 | 21 | 35 |
| Edmonton Ex | 19 | 10 | 29 |
| Melloy | 35 | 8 | 43 |