Revenue for 2023 × East

Power BI DAX practice question · Medium · CALCULATE & Filters

The e-commerce lead is reviewing one specific slice of the business: year 2023 combined with region East. Show its revenue by category.

Task: Create [East 2023 Sales] = [Total Sales] where 'Date'[Year] = 2023 AND Region[Region] = "East".

Visual: bar by Product[Category]

Solve it in the live editor on this page — run on sample data, then submit against hidden tests.

‹ Revenue for Black × Components · Units sold for Q2 × Accessories ›

Revenue for 2023 × East – Power BI DAX Practice Question | TechTown
T
Tech Town
Hi, {{ authName }} · Dashboard Log Out Log In Sign Up Free
Power BI DAX Practice

Practice DAX Online

{{ totalCount }} questions · {{ shHardPct }}% Hard. Scenario-based DAX measures on a Sales star-schema model. Write a measure, compare your visual with the expected result in the live simulator, then submit against hidden filter tests.

{{ totalCount }}
Questions
{{ shTopicCount }}
Topics
{{ solvedCount }}
Solved
{{ accuracy }}
Acceptance
Bookmark Question Topic Difficulty Status
{{ r.n }} - {{ r.title }}{{ r.badge }}{{ r.lock }} {{ r.topic }} {{ r.difficulty }} {{ r.statusIcon }}
No questions match these filters.
Showing {{ shRange }} of {{ shFilteredCount }}

Guests can solve {{ freeLimit }} problems for free. Log in or sign up (free) to unlock everything, keep your streak and appear on the leaderboard. New to a topic? Learn it first in the Power BI course.

{{ q.num }}. {{ q.title }} {{ q.difficulty }} {{ q.topic }} {{ q.solvedLabel }} Simulated – not Power BI
{{ shPointsLabel }} ⏱ {{ shTimer }}
Embed this questionPaste on a blog, course page or LMS. Free to use — educator guide
{{ shEmbedCode }}

Data model

Star schema · click a table
OrderDate (active) · ShipDate (dashed, inactive)

Every relationship is one-to-many (1 → *) and filters flow from the dimension to Sales. 'Date' is marked as a date table.

{{ preview.title }} {{ preview.count }} rows · first 6 shown
{{ pc.name }}
{{ cv }}
Base measures
Hidden for this question — build the logic from columns.

{{ q.scenario }}

Task: {{ q.task }}
Measure name: [{{ q.measure }}] · Visual: {{ q.visualLabel }}
Target visual — expected result {{ slicerSummary }}
{{ tv.card }}
{{ q.measure }}
{{ b.label }}
{{ b.expTxt }}
{{ tv.firstLabel }}max {{ tv.maxTxt }}{{ tv.lastLabel }}
{{ tv.rowHeader }}{{ q.measure }}
{{ b.label }}{{ b.expTxt }}
{{ tv.rowHeader }}{{ ch }}
{{ mr.label }}{{ mc.exp }}
DAX editor Suggestions from the model as you type · Ctrl/⌘ + Enter to run
{{ ac.note }}
↑↓ choose · Enter / Tab insert · Esc close
{{ ac.warn }}
{{ sp.t }} — {{ sig.desc }}
⚠ Schema check: {{ lw }}
{{ verdict }} {{ verdictDetail }}
{{ errorText }}
{{ tr.label }}
{{ tr.detail }}
  1. {{ h }}

{{ supported }}

Learn the concept first: {{ q.topic }} in the Power BI course
Your submissions (last 20, saved on this device)

No submissions yet. Press Submit to judge your code against all tests.

{{ sb.verdict }}
{{ sb.meta }}
🔒 Solution locked

The model solution and step-by-step explanation unlock when you solve this problem or after 3 unsuccessful submissions ({{ shFailsLabel }}). Struggling? Try the hints on the Question tab first.

{{ q.solution }}
How it works — step by step
  1. {{ st }}

Live output

Simulated – not Power BI
Run your measure to draw it here next to the expected result. Change the slicers to test it under different filters.
{{ runErrorText }}
{{ out.summary }} Expected Yours
Expected
{{ out.cardExp }}
Yours
{{ out.cardYours }}
{{ b.label }}
{{ b.mark }}
{{ out.firstLabel }}{{ out.lastLabel }}
{{ out.rowHeader }}{{ ch }}
{{ mr.label }}{{ mc.yours }}

Green cells match the expected value, red cells differ (hover a cell for the expected value).

{{ out.rowHeader }}ExpectedYours
{{ b.label }}{{ b.expTxt }}{{ b.yourTxt }}{{ b.mark }}

Rows where both values are blank are hidden, as in Power BI. Blank and 0 are treated as equal when checking. Submit also tests 7 hidden slicer combinations.

Enjoying DAX practice?

Create your free TechTown account to unlock all 250 DAX scenarios, track your progress, bookmark questions and keep preparing for Power BI interviews.

Log in / Sign up