| name | topdesk-powerbi-dax |
| description | Use when creating, reviewing, or standardizing Power BI DAX measures for TOPdesk incidents, SLAs, backlog, routing, operators, branches, AI governance, adoption, quality, cost, risk, and executive service-management dashboards. |
TOPdesk Power BI DAX
Use this skill after the semantic model grain is known and before visuals are finalized.
Workflow
- Define each measure with business meaning, grain, date basis, and exclusions.
- Prefer explicit measures for counts, backlog, SLA, MTTA, MTTR, reopen rate, routing quality, and AI adoption.
- Keep date intelligence tied to conformed
DimDate and clearly named date roles.
- Use disconnected parameter tables for KPI switching only when it improves report UX.
- Validate every measure against REST/API samples or exported reconciliation totals.
Assets
- Use
assets/topdesk-core-measures.dax as a starter measure pack.
Scripts
- Use
scripts/new_dax_measure_pack.py with a tenant field catalog to generate a customized DAX starter pack and measure catalog.