Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create average line from analytics using a measure

Hi all,   I have a visual that tracks how long it takes a technical service center to resolve various faults using a line and stacked column chart. The solid line is the average time it take...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Have tried a line with allselected ?

Try Like

Dwell = calculate( AVERAGE('Case File Data'[Dwell (days)]) , allselected('Case File Data'))
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak 

     

    I had previously tried that just using ALL rather than ALLSELECTED, but I gave your suggestion a try just in case. It seems to also produce a line that matches the line measuring the average per fault rather than a flat reference line.