Calculate percentage of entries >x days

[uie79957]

Hi there, 

I am struggling writing a DAX code for following calculation. I have the table below (simplified) and I want to calculate the share of customer complaints with a processing time >42 days. The column "processing time" is calculated from "date opened" and "date closed"

Customer Complaint Claim ID	Date Opened	Date Closed	Processing Time
1	23.08.2021	30.11.2021	99
2	29.09.2022	30.09.2022	1
3	07.06.2022	11.07.2022	34
4	...	---	---
5	...	---	---
6	...	---	---
7	...	---	---

Thanks for your support

[johnt75]

You could create a measure like

Percent overdue =
VAR TotalComplaints =
    COUNTROWS ( 'Table' )
VAR ComplaintsOver42 =
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Processing time] > 42 )
RETURN
    DIVIDE ( ComplaintsOver42, TotalComplaints )

[amitchandak · Accepted solution]

@uie79957 , if you do not have Processing Time

a new column

Processing Time= datediff([OpenDate], [Close Date], Day )+1

A new measure

divide(countrows(filter(table, Table[Processing Time] >42)), countrows(table))