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 !!!
AlBCommunity Champion5 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
Related contentMeasure returning incorrect valueMeasure is returning BLANKDAX Measure Returning Incorrect ResultsCreate Measure to Return Highest ValueDAX Measure Returns (BLANK)
