Forum Discussion
90th Percentile Issues (Not displaying correctly)
Yes. If you do not already have an Index, you can create a Calculated Column as follows.
NOTE: I am assuming you have an ID in your table. Since you have duplicate values in the Unit Turnout Time, you need a way to differentiate between duplicates to assign different ranks for the same Unit Turnout Time. In this example, I'm simply adding the ID to the Unit Turnout Time to get a unique value on which to properly rank all values.
Once your Index column exists, just update the measure to refer to it inside the CALCULATE.
Hope this makes sense.
Nathan
Impactful Individual
Yes. If you do not already have an Index, you can create a Calculated Column as follows.
NOTE: I am assuming you have an ID in your table. Since you have duplicate values in the Unit Turnout Time, you need a way to differentiate between duplicates to assign different ranks for the same Unit Turnout Time. In this example, I'm simply adding the ID to the Unit Turnout Time to get a unique value on which to properly rank all values.
Once your Index column exists, just update the measure to refer to it inside the CALCULATE.
Hope this makes sense.
Nathan
WinterMist - I am not sure if what I am trying accomplish is going to work or either i'm losing faith. I don't have any sort of ID in the table either. Here is a quick snipit of the actual table and the sepcific data in said table.
So for example, each unit has its own turnout time for each specific incident. I am wanting to take the turnout time for said unit and display it in th e 90th percentile accounting for specific slicer filters (that is another conversation).
