Trying to get average Revenue by hour measure

[Anonymous]

Hi, 

I'm trying to get the average rev by hour, I have a calculated column that extracts the HOUR from my date/time column. I then want the average revenue that is produced in each hour. 

I have the following DAX that I thought would give me this value, but when put into my visual it gives me the total value. 

Average Revenue by Hour = AVERAGEX( VALUES('Transactions'[Purchase Hour]), [Revenue] )

Any help greatly appreciated!

[Kishore_KVN]

Hello @Anonymous ,

Please use ALLEXCEPT function to calculate for specific hours. So your measure should be :
Average Revenue by Hour = Calculate(AVERAGEX( VALUES('Transactions'[Purchase Hour]), [Revenue] ),
ALLEXCEPT('Table Name','Table Name'[Hour_Column])
This will give you average by hours. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Anonymous]

This is still giving me the total revenue for each of the hours and not the average rev.