Aggregation Measures Quiz

What you'll be asked

1. Which DAX function would you use to calculate the total sum of a column named 'SalesAmount'?
2. You need to calculate the average price of products, but you want to ensure that only rows where 'Price' is greater than zero are included. Which measure is most efficient?
3. What is the primary difference between using COUNT and COUNTAX in DAX?
4. If you want to find the highest sales value in your 'Sales' table, which function should you use?
5. You have a measure [Total Sales] defined as SUM(Sales[Amount]). You want to create a new measure that calculates the average sales per transaction, but you want to ensure the denominator is never zero to avoid errors. Which function handles this best?

Answers and explanations come after you submit.