Average line of multiple lines in a line chart

[Anonymous]

Hello,

I have a data as the following:

time	attribute	value
1	FIFO1	2
2	FIFO1	16
3	FIFO1	5
4	FIFO1	64
5	FIFO1	98
6	FIFO1	83
7	FIFO1	8
8	FIFO1	79
9	FIFO1	54
10	FIFO2	80
1	FIFO2	53
2	FIFO2	62
3	FIFO2	65
4	FIFO2	52
5	FIFO2	59
6	FIFO2	60
7	FIFO2	8
8	FIFO2	69
9	FIFO2	48
10	FIFO2	61
1	FIFO3	59
2	FIFO3	24
3	FIFO3	32
4	FIFO3	52
5	FIFO3	1
6	FIFO3	58
7	FIFO3	89
8	FIFO3	29
9	FIFO3	68
10	FIFO3	62

And I am getting the line chart from it while adding a filter for the attribute as above. So my request is that I want to add an average line for the lines checked on the filter whataver that be (FIFO1 and FIFO2 or FIFO2 and FIFO3 or all of them). So for example for the lines choses above the average will be something like the red line that I drew by hand:

Any help will be appreciated. I have the sample file but I am unable to share it here.

[barritown · Accepted solution]

Hi @Anonymous,

You could use each line separately using measures like this one (and not using the Legend option):

Line 1 = SUMX ( FILTER ( Data, [attribute] = "FIFO1" ), [value] )

Then the average measure will be as simple as this:

Avg = AVERAGE ( Data[value] )

Please find the attached file illustrating this approach.

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

[barritown · Accepted solution]

Hi @Anonymous,

You could use each line separately using measures like this one (and not using the Legend option):

Line 1 = SUMX ( FILTER ( Data, [attribute] = "FIFO1" ), [value] )

Then the average measure will be as simple as this:

Avg = AVERAGE ( Data[value] )

Please find the attached file illustrating this approach.

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

[Anonymous]

Thank you @barritown , this is a brilliant solution. The only problem I had is that the number of FIFO are actually more than 3 in my real data and creating a measure for every FIFO number could be very manual especially that the number of FIFO could change from 7 to 8 or 20.

[Ahmedx · Accepted solution]

if FIFO is actually greater than 3 you can use my solution

[Anonymous]

This is exactly what I was looking for, @Ahmedx ! Thank you, I appreciate the help.