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 & monitor' and '4 gas' are taken per company and not broken up between the foreman.
I will post a pic of the 'transformed data'
10 Replies
could you pls paste the sample data (not the screenshot)?
What's more, what is the expected output? what's the logic of calculation?
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?
you can directly copy paste the data in the reply like below
column column2 a 1 b 2 c 3
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!
Good Morning,
Unfortunatly this did not work for me, I'm trying to post the data but it wont let me.
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?
