average based on date slicer

Hi Anonymous ,

I have tested sudhisami_azure 's solution and there is no error, here is the test results:

Total = COUNT('Table'[Count])

Average = AVERAGEX(VALUES('Table'[Date]), [Total])

60 / 28 =2.14285......

Or you can try:

Average 2 = 
VAR _Date = DISTINCTCOUNT('Table'[Date])
RETURN
[Total] / _Date

If you still can't implement it, then there is a problem with your data structure and not with DAX, as ryan_mayu  said, please provide sample data or a pbix file.

Best Regards,
Dino Tao
If this post helps, then please consider Accept both of the answers as the solution to help the other members find it more quickly.