Forum Discussion

tbrown33's avatar
tbrown33
Regular Visitor
4 years ago

Data Model measure not working

This measure was created on a data model to show the average over time to include months an entry may not be made.  This worked fine until an update was made to the model.   The new model is built in...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

tbrown33 , I doubt you should use 0, assume this is a measure - [Total Regular&Premium Hours]

 

AVERAGEX(VALUES(DimCalendar[FYMonth]),[Total Regular&Premium Hours])

 

or

 

AVERAGEX(VALUES(DimCalendar[FYMonth]),[Total Regular&Premium Hours]+0)