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
DimDateand 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.daxas a starter measure pack.
Scripts
- Use
scripts/new_dax_measure_pack.pywith a tenant field catalog to generate a customized DAX starter pack and measure catalog.