# Powerbi Dax Unit Test Runner

> Use when DAX measures require executable or semi-executable unit tests, query-based assertions, XMLA or Tabular Editor validation, edge cases, totals, RLS contexts, and reconciliation evidence.

- Skill: `rweisssieker-xp/powerbi-dax-unit-test-runner` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/powerbi-dax-unit-test-runner`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/powerbi-dax-unit-test-runner/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/powerbi-dax-unit-test-runner

---


# Power BI DAX Unit Test Runner

Design DAX tests that can be executed through DAX queries, XMLA, Tabular Editor workflows, or documented manual evidence.

## Output Contract

- Measure under test, KPI contract, expected result, filter context, date context, and RLS context.
- Test cases for totals, blanks, zero denominators, many-to-many risk, time intelligence, currency, and segment filters.
- Execution route: DAX query, Tabular Editor script, XMLA endpoint, Performance Analyzer export, or manual reconciliation.
- Pass/fail criteria, evidence capture, owner, and remediation.

## Checks

- Do not treat visual inspection as sufficient for certified measures.

## Runtime Executor

For dataset-backed DAX validation, create a credential-safe DAX query request:

```powershell
python scripts\powerbi_expert_factory.py dax-query-request --workspace <workspace-id> --dataset <dataset-id> --query "EVALUATE ROW(\"Cases\", [Case Count])" --out outputs\runtime-executors\dax-query-request.json
```