Counting Units Per Company

[Gasdetect40]

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 & monitor' and '4 gas' are taken per company and not broken up between the foreman.

I will post a pic of the 'transformed data' 

[johncolley]

Hi @Gasdetect40 , You can create a measure like the following to create the total (gas & pmup) for each line:

Gasandpump = SUMX ('Tablename', 'Tablename'[gas] + 'Tablename'[pump])

You then put this in a table or a graph with the company column and it will summarise the totals per company. 

If this answer solves your problem please mark it as a solution!

[Gasdetect40]

Good Morning, 

Unfortunatly this did not work for me, I'm trying to post the data but it wont let me. 

[johncolley]

Hi @Gasdetect40 , Can you be more specific as to what didn't work. Were you able to create the measure? Or was it not displaying as you wanted?

[ryan_mayu]

could you pls paste the sample data (not the screenshot)?

What's more, what is the expected output? what's the logic of calculation?

[Gasdetect40]

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]

you can directly copy paste the data in the reply like below

column	column2
a	1
b	2
c	3

[Gasdetect40]

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]

@Gasdetect40 

it looks like the calculation logic is SUM

what's more, why we don't want to show the data of clean harbors?

[Gasdetect40]

I'm sorry, that was my mistake. I forgot to include Clean Harbors

[ryan_mayu]

@Gasdetect40 

i don't even think you need to create a measure,just drag columns to a table visual