Percentile line on analytics

Question

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 calculated value (=percentile.inc(,0.9)).

This is the same when I use the average line and calculate the average (=average()).

Does anyone know why the values are different and how I can get them the same?

Thanks

P.s. I do have a few filters applied on the page but when I change the filters, the calculated fields and the analytic lines change with them so I don't think thats the problem.

williamdlupo · Answer

I do not want to come across as rude, but that answer makes no sense and does not address the orignal issue at all.&nbsp;&nbsp;&nbsp;Best regards though!!

v-jiascu-msft · Answer

Hi&nbsp;Silver,&nbsp;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&nbsp;is 'Calendar[Date' while the value is SUM(Sales[Quantity]).&nbsp;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.&nbsp;&nbsp;Best Regards!Dale

silver · Answer

Thanks for the reply. I've tried your formula but it gave me a really large number.&nbsp;Here is an example of my data:&nbsp;Colour&nbsp; Letter &nbsp; Date/time &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; valuered &nbsp; &nbsp; &nbsp;&nbsp; A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2017/12/12&nbsp; 01:00:00 &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; 2blue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2017/12/12&nbsp;&nbsp; 01:00:00 &nbsp; &nbsp; &nbsp; &nbsp; 5red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2017/12/12&nbsp;&nbsp;&nbsp; 12:00:00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4green&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2017/12/12 &nbsp; 08:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2017/12/12 &nbsp;&nbsp; 14:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;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.

Forum Discussion

Percentile line on analytics

3 Replies

Related content

Line chart

Line Chart Analytics

Missing Trend Line and Forecast options in Analytics

Percentile

Percentile