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
Yeah, I'm out of ideas unfortunately.
A solid data source should have a unique ID column in each table in the model.
Without a unique ID, we have no way of ranking the Unit Turnout Time due to duplicate values.
And without being able to rank the values, how can Power BI be able to identify the Nth value in the list (in this case the 21st)? It cannot.
Perhaps someone else in the community knows of a different route to take?
I am sorry I was not able to provide a solution.
Regards,
Nathan
Don't be sorry, you helped tremendously. I will work on seeing if I can get a unique ID to drop in with the data.