dax formula to calculate company totals

[metal123]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Company Name[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Company A[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Company A[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Company C[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Company B[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]Company A[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Company C[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]Company B[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]Company B[/TD]
[TD]1000[/TD]
[/TR]
</tbody>[/TABLE]

In this example,
Company A=300
Company B=2100
Company C=700

I would like to utilize a dax function that calculates the totals of all the companies in the data set.

I have tried using this example,
SUMX() - The 5-point palm, exploding fxn technique - PowerPivotPro

I was successful in getting the results in the example, but was not able to apply it to my data set. Any suggestions or solutions?

 

[Matt Allington]

There are lots of ways to do this and there is a quick and dirty way. But I recommend learning best practices as you start out even for simple examples.
1. What you have posted is a data table (I will call it DATA). You should create a lookup table that consists of all the company names (I will call the table COMPANIES and the column COMPANY) - 1 record for each unique name. Then join the data table to this new lookup table. Read about data shape in my knowledge base here => The Optimal Shape for Power Pivot Data -
2. Create a pivot table connected to your data model. Place the COMPANY column from your COMPANIES lookup table on rows in your pivot table.
3. Select the pivot table and then write the following measure (calculated field in Excel 2013).
=SUM(Data[Amount])

This new measure should be placed in your pivot table automatically after saving and will give you the result.

 

[metal123]

Hello, Matt thank you for the reply. I realized that I already know how to do this. In addition, I realized that i actually incorrectly wrote my question. My question is actually the following link.

http://www.mrexcel.com/forum/power-bi/919995-help-dax-formula.html#post4422601