Repair category shares within the selected population
A hands-on PL-300 lab. You produce the real artefact and 9 automated checks verify it behaves the way the exam expects.
Try this labAll PL-300 practice
- Certification
- PL-300
- Format
- Structured configuration
- Difficulty
- medium
- Estimated time
- 30 min
- Automated checks
- 9
The brief
Edit share.measures.json with measures.CategoryShare as a formula string. Supported scalar expressions are SUM(Sales[Amount]), COUNTROWS(Sales), [Revenue], DIVIDE(numerator,denominator[,integer alternate bounded to +/-999999999]); supported CALCULATE takes an aggregate and up to three distinct column modifiers: Category ALLSELECTED/ALL or REMOVEFILTERS on a supplied column. SUMX takes ALLSELECTED/ALL/VALUES on Product[Category] and a base measure, bare aggregate, or CALCULATE(aggregate). One iterator and the declared bounded formula depth are allowed; unsupported DAX is rejected. Region and year remain external filters. The visual Category row restricts the numerator, while external category selections restrict the denominator and the row. Sum each selected fact amount once. Use alternate 0 for blank or zero denominator; a blank numerator over a positive denominator remains JSON null. Inspect actual numerator/denominator identities, values and iterator contributions; repair without Reset and test all populations.
What the checks verify
Your work is graded on 9 independent properties, not on matching one reference answer.
- Compile the declared ratio measure using only the stated DAX subset.
- Each category row keeps its own numerator while its denominator includes the selected category population.
- A changed region restricts both the row numerator and selected-category denominator.
- A different year retains its own observations and amounts in both parts of the ratio.
- Two different external category selections produce their own denominators without adding unselected categories.
- A subtotal aggregates the selected observations once and yields their revenue divided by the same selected total.
- A matched zero-amount fact remains a real numerator observation, while a category without facts has a blank numerator.
- An empty year or explicit empty category selection has blank aggregates and the stated zero alternate ratio.
- Offsetting positive and negative observations remain in a real zero denominator, with the stated zero alternate.
Where this sits in the PL-300 blueprint
- Domain
- Model the Data
- Objective
- Create Model Calculations by Using DAX
- Skill
- Filter Context
Part of PL-300 preparation
Labs are written by ExamNova to teach the decisions the exam tests. They are not reproductions of vendor lab content.