Forum Discussion

rh203's avatar
rh203
Icon for Helper I rankHelper I
3 years ago

Percentile, ignoring date dimension for graph

Hi,

 

I have a data set for which I cam trying to calculate a percentile of the total values for a time horizon with the intention of then positoning it against the data in a chart to see which periods go above or below the quartile (percentile) for the full period of data.

 

Unfortunately the measure appears to change along each of the dates instead of remain constant... I assume this is something to do with it factoring in the date dimension table...

 

Data model (redacted - sorry - please let me know if any fields are needed) and measure below...

 

Has anyone any ideas?

 

black bar is

 

 

 

 

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion

    QUARTILE TEST=PERCENTILEX.INC(ALLSELECTED(PFR_CUSTOMER_LEVLEL),PFR_CUSTOMER_LEVLEL[[Quantity Shipped (CA)]],1)