Total average as measur

[#1]

Hi,

Problem is how to create a measure of total average. I hava fields Date and Visits. I want to display average per day calculated on total numbers on the graph. Problem is that if I make a selection of Dates then average is calculated on the basis of the selection. Expression that I try to use is following:

SUM(Total  [Car Chapter Total Visits])/Count(Distinct Week(Date))

How can I make this work?

BR

Meelis

[MK_QSL]

SUM({<Date=>}Total  [Car Chapter Total Visits])/Count({<Date=>}Distinct Week(Date))

or

SUM({1}Total  [Car Chapter Total Visits])/Count({1}Distinct Week(Date))

[rubenmarin]

Hi, not sure to understand but you tried this?:

SUM(Total  [Car Chapter Total Visits])/Count(Total Distinct Week(Date))