One value or nothing: SELECTEDVALUE
A product’s list price makes sense in a product row, but not in a category subtotal that holds several products. SELECTEDVALUE(column) returns the value when the filter context leaves exactly one, and BLANK otherwise.
It is short for IF(HASONEVALUE(column), VALUES(column)). Both keep subtotals and totals empty instead of showing a misleading maximum or sum.
Your task
Write List Price that shows Product[List Price] in each product row, and nothing in the category subtotals and the total.
About this exercise
You practise measures that only make sense for one item with SELECTEDVALUE and HASONEVALUE. The exercise runs on a small bike-shop model with a Sales fact table and Product, Customer and Date dimensions, the same star schema in every lesson.
Your measure, List Price, fills a Power BI-style matrix grouped by Product[Category] and Product[Product]. As in a real report, each cell evaluates the measure in its own filter context, and the subtotals and the grand total are evaluated again in theirs rather than added up. When you check your answer, every cell is compared with the expected value, wrong cells are marked, and the hint is about the mistake you made.
Measures that already exist in the model: Sales Amount. Reference them in square brackets, for example [Sales Amount].
Where you start
List Price =The result to build
| Category › Product | List Price |
|---|---|
| Accessories | |
| Bike Lock | 29.00 |
| Helmet | 49.00 |
| Water Bottle | 9.00 |
| Bikes | |
| City Bike | 790.00 |
| Road Bike | 1,650.00 |
| Trail Bike | 1,200.00 |
| Clothing | |
| Cycling Jersey | 59.00 |
| Rain Jacket | 119.00 |
| Total |
Last updated 10 November 2026
Opening the exercise…