[All skill tests](https://jobicy.com/tests.md) Skill assessment # Power BI DAX Measure Context and Time Intelligence Skills Test This test evaluates the design of reliable Power BI DAX measures for analysis across filters, relationships, dates, and totals. It focuses on how evaluation context affects reported business metrics. [Start the test](#test-start) Share Assessment setup Ready ## Choose the level that matches your current experience. * 01 Basic Available * 02 Intermediate Available * 03 Advanced Available Instant result Review your score after submission 20–30 Questions per assessment 15–45 min Estimated completion time 3 levels Choose your difficulty BI Tools & Dashboards [View category](https://jobicy.com/test-category/bi-tools-dashboards.md) Start assessment ## Choose your level and begin. Answer without outside help so the result reflects your current knowledge. You will see your score after completing the selected assessment. DAX measures turn a semantic model into consistent business reporting. Knowing how filter context, row context, CALCULATE, iterators, relationships, and date functions interact helps analysts create visuals whose values remain trustworthy as users slice, drill, and compare periods. Basic Intermediate Advanced This is a demo version of the test. You may attempt up to 3 questions. To take the full test and save your results, please [log in](https://jobicy.com/dashboard-page.md) or [create an account](https://jobicy.com/dashboard-page#tab2.md). This is a demo version of the test. You may attempt up to 3 questions. To take the full test and save your results, please [log in](https://jobicy.com/dashboard-page.md) or [create an account](https://jobicy.com/dashboard-page#tab2.md). This is a demo version of the test. You may attempt up to 3 questions. To take the full test and save your results, please [log in](https://jobicy.com/dashboard-page.md) or [create an account](https://jobicy.com/dashboard-page#tab2.md). Test details ## Know what to expect. Review the instructions, covered skills, example question themes, and intended audience before beginning. 01 ### Instructions and covered skills Read each question carefully before selecting an answer. Focus on the stated model, filters, and calculation requirements. Do not assume that a visual total behaves like a sum of visible rows unless the formula supports that behavior. Work in a quiet setting and turn off notifications before starting. Avoid rushing through DAX function names that appear similar but alter context differently. Review each selection for alignment with the requested reporting outcome. ### Key Areas This test covers the DAX measure patterns used to produce dependable Power BI reports. Candidates should understand how measures are evaluated in the filter context supplied by visuals, slicers, page filters, report filters, and model relationships. They should be able to distinguish this context from row context and recognize when iterator functions such as SUMX, AVERAGEX, and COUNTX evaluate an expression once for each row of a table. Strong performance requires practical use of CALCULATE to modify filters, including removing filters with REMOVEFILTERS, retaining existing filters with KEEPFILTERS, and applying targeted conditions through filter arguments. The assessment also addresses relationship-aware calculations, including when RELATED, RELATEDTABLE, USERELATIONSHIP, and CROSSFILTER are appropriate. Candidates should understand how active and inactive relationships affect a measure result. Date-based reporting is another key area. This includes using a marked date table, creating period comparisons, calculating year-to-date values, and handling common functions such as DATEADD, SAMEPERIODLASTYEAR, TOTALYTD, and DATESYTD. Candidates should also understand why time calculations depend on a complete, contiguous calendar table related to the relevant fact date. The test evaluates measure design for ratios, totals, conditional logic, and blank handling. Important concepts include DIVIDE, VAR, RETURN, ISINSCOPE, HASONEVALUE, SELECTEDVALUE, COALESCE, and the difference between a calculated column and a measure. It also considers methods for making totals reflect intended business logic rather than merely repeating a row-level expression. ### Recommended Preparation Prepare by building measures in a small star-schema model containing a sales fact table, product and customer dimensions, and a dedicated calendar table. Practice placing the same measure in cards, tables, matrices, and charts while changing slicer selections. Inspect how the result changes at detail rows, subtotals, and grand totals. Write alternative formulas for the same metric and explain which filters each formula preserves, replaces, or removes. Validate period comparisons against a known set of dates, including months with no transactions. Finally, use descriptive measure names, variables, and formatted DAX so that calculation intent can be reviewed and maintained by others. 02 ### Examples of questions 1. Which DAX function changes filter context while evaluating an expression? 2. When does a measure receive filter context from a matrix visual? 3. Which function iterates a table and returns the sum of an expression? 4. What is required for standard year-to-date calculations in a model? 5. How can a measure remove a filter from one dimension column? 6. What does RELATED retrieve when used from the many side of a relationship? 7. Which function returns the selected value when one value is in context? 8. Why might a percentage measure show an unexpected grand total? 9. Which DAX pattern calculates sales for the prior calendar year? 10. What effect does KEEPFILTERS have inside CALCULATE? 03 ### Who this test is best for Power BI analysts, reporting specialists, finance analysts, operations analysts, and data professionals who create or maintain DAX measures. Related assessments ## Continue with a similar skill test. Explore assessments from the same professional area to compare adjacent skills and build a broader picture of your knowledge. [Statistics & Experimentation 3 levelsA/B Test Statistical Inference and Experiment Analysis Skills TestThis test evaluates the statistical reasoning used to design, analyze, and communicate A/B test results. It focuses on valid comparisons, uncertainty, decision rules,… Open assessment →](https://jobicy.com/tests/a-b-test-statistical-inference-and-experiment-analysis-skills-test.md) [Data Quality & Governance 3 levelsData Lineage Mapping and Impact Analysis Skills TestAssess the ability to document data movement, trace transformations, and evaluate downstream consequences of change. This test focuses on practical lineage records that… Open assessment →](https://jobicy.com/tests/data-lineage-mapping-and-impact-analysis-skills-test.md) [Excel & Google Sheets 3 levelsExcel and Google Sheets Lookup Formula Design Skills TestThis test evaluates the ability to retrieve, match, and validate data with lookup formulas in Excel and Google Sheets. It focuses on selecting… Open assessment →](https://jobicy.com/tests/excel-and-google-sheets-lookup-formula-design-skills-test.md) [SQL & Databases 3 levelsPostgreSQL Index Design and Query Plan Analysis Skills TestEvaluate how well you design PostgreSQL indexes and interpret query execution plans. The test focuses on matching index structures to query predicates, joins,… Open assessment →](https://jobicy.com/tests/postgresql-index-design-and-query-plan-analysis-skills-test.md) [Data Interpretation & Visualization 3 levelsTableau Dashboard Design and Visual Encoding Skills TestAssess the ability to design Tableau dashboards that communicate data clearly and support sound decisions. The test focuses on chart selection, visual encodings,… Open assessment →](https://jobicy.com/tests/tableau-dashboard-design-and-visual-encoding-skills-test.md) [Business Metrics & KPI Analysis 3 levelsSaaS Cohort Retention and Churn Analysis Skills TestThis test evaluates the ability to build, interpret, and act on SaaS customer retention cohorts. It focuses on consistent cohort definitions, retention calculations,… Open assessment →](https://jobicy.com/tests/saas-cohort-retention-and-churn-analysis-skills-test.md) [Business Metrics & KPI Analysis 3 levelsRole-Specific KPI Identification Skills TestThis test evaluates your ability to select the most relevant Key Performance Indicators for various digital roles. Master this skill to ensure your… Open assessment →](https://jobicy.com/tests/role-specific-kpi-identification-skills-test.md) [SQL & Databases 3 levelsSQL JOINs and Multi-Table Queries Skills TestMaster the art of combining data from multiple tables using SQL JOINs. This test evaluates your ability to write efficient queries using various… Open assessment →](https://jobicy.com/tests/sql-joins-and-multi-table-queries-skills-test.md) [Data Interpretation & Visualization 3 levelsData Storytelling Techniques Skills AssessmentThis assessment evaluates your ability to craft compelling narratives using data. It covers key techniques for turning raw numbers into actionable insights. Open assessment →](https://jobicy.com/tests/data-storytelling-techniques-skills-assessment.md) ## Share the assessment or try another skill. Send this test to a colleague or friend, or return to the assessment library to explore another professional area. Share this test [Browse all tests](https://jobicy.com/tests.md)