Show Value as linear line

[joshua1990]

Hi all!

I have a Sales table and a hierarchy table:

Sales

Sales Order	Age	Date	Article
100	550	01.01.2022	ABC
101	640	05.01.2022	DEF

Hierarchy

Article

ABC

DEF

Now I have calculated the 1. Quartile using this measure:

QUARTILE1 = PERCENTILE.INC(Sales[Age],0.25)

Now I would like to show the 1. Quartile and Age on a bar chart.

The Age should be displayed as calculated for each date.

But the 1. Quartile should be displayed as a linear line as the total Quartile for the selected value.

How can I remove the relation to the date? Is always shows the 1. Quartile for the date and not as an average for the full time.

[tamerj1 · Accepted solution]

Hi @joshua1990 

please try

AVERAGE QUARTILE1 =

AVERAGEX ( ALLSELECTED ( Sales[Date] ), [ QUARTILE1] )