Microsoft Power BI Data Analyst — Question 77

You have a Power BI model that contains a table named Expenses. The table contains the following columns:

• Date
• Amount
• Category
• Expense ID
• Employee ID

Expenses are recorded by employees, and each expense has a unique expense ID.

You need to create a DAX measure that will calculate the total amount of expenses.

Which DAX expression should you use?

Answer options

• A. Sum(‘Expenses’[Amount])
• B. Max(‘Expenses’[Amount])
• C. Sum(‘Expenses’[Expense ID])
• D. Count(‘Expenses’[Amount])

Correct answer: A

Explanation

The correct answer is A, as the Sum function effectively aggregates the total values in the 'Amount' column, providing the total expenses. Option B, Max, only retrieves the highest value, while C incorrectly sums the Expense ID, which does not represent a monetary value. Option D counts the entries in the 'Amount' column, rather than calculating the total sum of expenses.