Percentile, ignoring date dimension for graph

[rh203]

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

[wdx223_Daniel]

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