Core risk measures

Risk Count = COUNTROWS(Risks)
Open Risks = CALCULATE([Risk Count], Risks[Status] <> "Closed")
High Severe Risks = CALCULATE([Risk Count], Risks[ResidualScore] >= 10, Risks[Status] <> "Closed")
Appetite Breaches = CALCULATE([Risk Count], Risks[AppetiteStatus] = "Breached")
Average Residual Score = AVERAGE(Risks[ResidualScore])
Overdue Actions = CALCULATE([Risk Count], Risks[ActionDueDate] < TODAY(), Risks[ActionStatus] <> "Closed")

Incident measures

Open Incidents = CALCULATE(COUNTROWS(Incidents), Incidents[Status] <> "Closed")
Reportable Incidents = CALCULATE(COUNTROWS(Incidents), Incidents[RegulatoryReportable] = "Yes")
Total Financial Impact = SUM(Incidents[FinancialImpact])

Credit measures

Watchlist Count = CALCULATE(COUNTROWS(Counterparties), Counterparties[Watchlist] = "Yes")
Total Exposure = SUM(Counterparties[TotalExposure])
Expected Loss = SUM(Counterparties[ExpectedLoss])
Average Internal Score = AVERAGE(Counterparties[InternalScore])

Liquidity measures

Latest LCR Proxy = MAXX(TOPN(1, Liquidity, Liquidity[Date], DESC), Liquidity[LCRProxy])
Latest Buffer Surplus = MAXX(TOPN(1, Liquidity, Liquidity[Date], DESC), Liquidity[BufferSurplus])
