Microsoft Power Bi Quiz
10 questions · no time limit
0:00
DAX AND MEASURES
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
A model contains
Sales[Quantity], Sales[ProductKey], and Product[List Price]. Each product has one current list price. The following measure returns expected values when a matrix is grouped by product, but the grand total is incorrect:
Revenue = SUM(Sales[Quantity]) * AVERAGE(Product[List Price])
The grand total must equal the sum of quantity multiplied by list price for every sales row.Which replacement measure should you use?
YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end