KBVelascoFrequent Visitor5 years agoSolvedModify this Measure to return 0 How can I modify the following measure to return a '0' instead of a blank? CALCULATE(AVERAGEX(TimeEntryUsers, [SumLoggedHours])) AlB5 years agoHi 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 Anand245 years agoHi 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 !!!
AlB5 years agoHi 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 Anand245 years agoHi 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 !!!
AlB5 years agoHi 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
Anand245 years agoHi 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 !!!
Anand24Super User5 years agoHi 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 !!!
Related contentMeasure returning incorrect valueMeasure is returning BLANKDAX Measure Returning Incorrect ResultsCreate Measure to Return Highest ValueDAX Measure Returns (BLANK)
