Reply
Member
Posts: 52
Registered: ‎02-22-2017

Graph doesn't place average per year correctly

Dear community,

 

I am wondering what is wrong with my DAX formula or with my graph.

 

I made a graph with on the axis, date and  on values I placed average per year.

The formula I am using to determine my average per year already got a date in it, it uses the date table.

I would like to get some help with figuring out where the problem is Smiley Happy

average amount of unique visitors  2016 = CALCULATE(
AVERAGEX('amount of unique visitors','amount of unique visitors'[amount of unique visitors]),
FILTER(
ALL(Datedimension[Datekey]),
and (
'Datedimension'[Datekey]>= DATE(2016, 1 , 1),
'Datedimension'[Datekey]<= DATE(2016,12,31)
)
)
)

Thanks in advance Smiley Happy