🔥 3-day streak
Microsoft Power BI Data Analyst126 / 205
Question 126 of 205
You maintain a Power BI model with a Sales fact table containing one row per order line, and an Orders table with one row per order. You need a measure that returns the average revenue generated per order (total sales divided by the number of distinct orders), and it must respond correctly to filters on product category, region, and date. Which DAX expression should you use?
Reviewed for accuracy · Report an issueNext question