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

williamdlupo's avatar
williamdlupo
Frequent Visitor
7 years ago

I do not want to come across as rude, but that answer makes no sense and does not address the orignal issue at all. 

 

 

Best regards though!!