Forum Discussion
KBVelasco
5 years agoFrequent Visitor
Modify this Measure to return 0
How can I modify the following measure to return a '0' instead of a blank?
CALCULATE(AVERAGEX(TimeEntryUsers, [SumLoggedHours]))
Hi KBVelasco
Just add a zero to it
0 + CALCULATE(AVERAGEX(TimeEntryUsers, [SumLoggedHours]))
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi KBVelasco ,
You can use the below DAX:
COALESCE(CALCULATE(AVERAGEX(TimeEntryUsers, [SumLoggedHours])),0)
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!