Forum Discussion

KBVelasco's avatar
KBVelasco
Frequent Visitor
5 years ago
Solved

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

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion

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