I want to calculate number of tickets open over 10 days

[Namrata95]

i want calculate MTTR over 10 tickets ,30,60,90 days not getting proper result

[v-nuoc-msft · Accepted solution]

Hi @Namrata95 

For your question, here is the method I provided:

Here's some dummy data

"Table"

Create measures to calculate the results you want.

OVER 10 DAYS = CALCULATE(DISTINCTCOUNT('Table'[tickets_id]), FILTER(ALL('Table'), 'Table'[date] >= TODAY() - 10))

OVER 30 DAYS = CALCULATE(DISTINCTCOUNT('Table'[tickets_id]), FILTER(ALL('Table'), 'Table'[date] >= TODAY() - 30))

Here is the result.

Regards,

Nono Chen

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