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...
johncolley
Solution Sage
Solution SageHi 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.
- 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?