i want to create a measure which gives the average value for a column(excluding any 0) and i'll add that measure to a line chart. once i applied date filter it should still show a fixed line but for filtered columns.
if i select all date range it should show a fixed line chart of value 5.14
if i select dates between 7/1-7/4 it should show a fixed line chart of value 4.75
below is the graph i want to get. blue line represent values over time and red line reprecent fixed average value for selected date range.