← Files Power BI DesktopARCHIVED FILE

examples/risky-model/Risk.Measures.dax

318 Bytes · Oct 2, 2026 · 00:32 UTC

↓ Download file

Tickets[Open Tickets] =
COUNTROWS(FILTER(ALL(Tickets), Tickets[Status] <> "Closed"))

Tickets[Overdue Tickets] =
CALCULATE(COUNTROWS(Tickets), Tickets[DueDate] < TODAY())

Tickets[Escalation Risk] =
DIVIDE([Overdue Tickets], [Open Tickets])

Tickets[Legacy Rank] =
SUMX(Tickets, EARLIER(Tickets[Priority]))

SHA-256: 9e3684e39bc2a21283bf41043ae1f7757fbe57bb7c368edfb9a5dbba8fde57d6