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...
Good morning, thank you for the reply.
I am unable to post the data, it says 'The file type (.xlsx) is not supported. How do I post the data properly?
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 - ryan_mayu
it looks like the calculation logic is SUM
what's more, why we don't want to show the data of clean harbors?
I'm sorry, that was my mistake. I forgot to include Clean Harbors