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?

Microsoft

PL-300 · Question #474

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

Sign in or unlock PL-300 to reveal the answer and full explanation for question #474. The question stem and answer options stay visible for context.

Submitted by yaw92· Apr 18, 2026

Question

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?

Options

ASum('Expenses'[Amount])
BMax('Expenses'[Amount])
CSum('Expenses'[Expense ID])
DCount('Expenses'[Amount])

Unlock PL-300 to see the answer

You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock PL-300 - $49.99 / 30 days Sign in

Full PL-300 Practice