Count of Items overDue >30 Days Measure

[RDS2017]

hello

I have a column for performed date and another column of Report date. I would like to create a measure that shows either

a. Of those performed, is the report date <30days

b. Of those performed, is the report date > 30 days

Both as percentage

[v-zhangti]

Hi, @RDS2017 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RDS2017]

Name	Performed Date	Report Date
xxx	12/05/2023	08/06/2023
xxx	20/05/2023	30/06/2023
xxx	20/05/2023	30/06/2023
xxx	20/05/2023	30/06/2023
xxx	08/05/2023	30/06/2023

[RDS2017]

The visual should show 4/5 completed were reported on time (<30days)

[v-zhangti · Accepted solution]

Hi, @RDS2017 

You can try the following methods.
Measure:

Days = DATEDIFF(Max('Table'[Performed Date]),Max('Table'[Report Date]),DAY)

Measure% = 
Var _count1=CALCULATE(COUNT('Table'[Name]),FILTER(ALL('Table'),[Performed Date]<>BLANK()&&[Report Date]<>BLANK()&&[Days]>30))
Var _count2=COUNTROWS(ALL('Table'))
Return
DIVIDE(_count1,_count2)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RDS2017]

Percentage > 30 Days =
DIVIDE(
COUNTROWS(
FILTER(
YourTableName,
NOT(ISBLANK(YourTableName[Performed Date])) &&
NOT(ISBLANK(YourTableName[Report Date])) &&
DATEDIFF(YourTableName[Performed Date], YourTableName[Report Date], DAY) > 30
)
),
COUNTROWS(YourTableName)
)

The visual shows up BLANK