Modify this Measure to return 0

[KBVelasco]

How can I modify the following measure to return a '0' instead of a blank?

CALCULATE(AVERAGEX(TimeEntryUsers, [SumLoggedHours]))

[AlB · Accepted solution]

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 

[Anand24 · Accepted solution]

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 !!!

[AlB · Accepted solution]

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