Using aggregate functions

When you create measures in PowerPivot you can run into unexpected problems when…you use functions such as SUM or COUNT.…In this movie I'll show you how to avoid those issues by using aggregate…functions such as SUMX and COUNTX.…So to begin let's go into PowerPivot.…Click the PowerPivot tab on the Ribbon and then the PowerPivot Window button and…our data reappears inside of PowerPivot.…Now in the previous movie I showed you how to create a calculated column and a measure.…

The difference between the two is that a calculated column uses values within…a table row to generate its result while a measure summarizes the values for an entire column.…This data model has two columns, Price and Quantity, that I can use to calculate a total.…I can if I want to create a calculated column such as by adding a formula equal…and I'm just repeating what I did from the previous movie. [Price]*[Quantity].…Press Tab to accept it and press Enter.…

So there is my calculated column and I won't bother renaming it this time.…