Forum Discussion

Silver's avatar
Silver
New Member
8 years ago

Percentile line on analytics

Does anyone know how they calculate the percentiles on the analytics pane?   I added onto my graph the 90th percentile line from the anlaytics pane but it is giving me a different value to my calcu...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Silver,

 

It's the context that has the magic. You can try a measure like this. I tested it in a simple column chart. The axis is 'Calendar[Date' while the value is SUM(Sales[Quantity]). 

average171024 =
CALCULATE (
    AVERAGEX (
        SUMMARIZE ( Sales, Calender[Date], "sq", SUM ( Sales[Quantity] ) ),
        [sq]
    ),
    ALL ( 'Calender' )
)

If you need more help, please provide a sample .pbix file. 

 

Best Regards!

Dale

Silver's avatar
Silver
New Member
8 years ago

Thanks for the reply. I've tried your formula but it gave me a really large number.

 

Here is an example of my data:

 

Colour  Letter   Date/time                            value

red        A           2017/12/12  01:00:00         2

blue      A           2017/12/12   01:00:00         5

red        A          2017/12/12    12:00:00        4

green     B           2017/12/12   08:00:00       1

red        A          2017/12/12    14:00:00      6

 

My line graph would be Average of value (y axis) against date/time (x -axis) with colour and letter as filters.
so technically, I want the percentiles for red,A.