Forum Discussion
average line
What you could do is to create the following measure which will then create the line across your dataset
Average Line = CALCULATE ( DIVIDE ( SUM ( '0426'[Update Rate] ), COUNTROWS ( '0426' ) ), ALL ( '0426' ) )And here is what it looks like once completed
And here is the updated file here: https://1drv.ms/u/s!Apxn-69XhcAmhqsVDkaulZTJN9sztA
Are you able to post more details of the set up of this? Its pretty difficult to guess what might be going wrong here. Are these lines coming from Measures? Can you post the Dax code of these measures? What can you tell us about the report these are on? What filters and context are you using?
Hi Ross,
Thanks very much for helping here. I tried to attached the sample dataset, but didn't find where to attach.
We didn't write Dax code, but import a excel dataset and drag and draw the charts. Here's the setting, the first one for the value on Table, and second one for the Average Line on Line Chart.
Hi liping_qin
Could you perhaps create a new measure which will be the Sum of your data.
Then when you create your Average Line, from the Measure drop down, select the average measure you just created.Hi GilbertQ,
Thanks for the workaround, I got the same value on the Average Line by creating a measure as (Measure = SUM('TREP_0426 updatestotalRatePerSe'[Update Rate])) and select this measure when adding Average Line.