Forum Discussion
Solved
Percentile using counts
I have found that to get percentile for counts based off day/hour I have needed to group by days or hours and do the counts in advance of doing the percentile calc or it would not work. Is there a b...
- NeverMind, found my own solution as it was just a typo that I couldn't help but recreate everytime. I blame temporary insanity.What the end result looked like:Calc 90th =PERCENTILEX.INC(KEEPFILTERS(VALUES('Table'[DateTime])),CALCULATE(COUNTA('Table'[ID#])), 0.9)
NeverMind, found my own solution as it was just a typo that I couldn't help but recreate everytime. I blame temporary insanity.
What the end result looked like:
Calc 90th =
PERCENTILEX.INC(
KEEPFILTERS(VALUES('Table'[DateTime])),
CALCULATE(COUNTA('Table'[ID#])), 0.9
)