% rows with valure greater than x amount

[ChiaraFru]

Dears,

I hav a list of issues IDs (TI ID) with some attitional attributes (like where happened, who managed to solde them etc..) and a measure for the time (days) spent to solve each issue.

I need to calculate the % of issues solved with resolution time greater than 5 days. I tried to create a calulated column like

=if(time to resolution>5,1,0), but then consolidating gives 0 since the sum of all the rows is >5 of course.

How to manage this?

Many thanks

[wdx223_Daniel]

NewMeasure=COUNTROWS(FILTER(ALLSELECTED(Table[TI ID]),[Time to Resolution]>5))

[ChiaraFru]

Hi.. it's not working since as time to resolution is doing the sum of all the time for all TIs.. now row by row

[wdx223_Daniel]

what's your raw data like? and  what's the forumla of [Time to resolution]?