Text in chart avg value

[#1]

Hello,

I have an average line for a chart and would like to show the value as 'Text in chart' in the presentation tab.  For some reason though, i am generating an error with this syntax.

=Avg(Sum({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty))

I do not want to use the 'y=' show eqution to display the value.  Is there any other way of doing this??

Thank You

[yduval75 · Accepted solution]

You have to use :

Avg({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty)

or

Sum({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty)

/

Count({$<Measure={1}, ProductId = {1}, Month = {1}>} DISTINCT ID)

[Michiel_QV_Fan]

replace sum with avg in your expression

avg({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty)

[#4]

So bc my expression was: Sum({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty),

Avg({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty) rendered a very small value that was wrong.

So, I wound up going with this:

Sum({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty)

/

Count({$<Measure={1}, ProductId = {1}, Month = {1}>} DISTINCT ID)

Thank you both