Forum Discussion
Helper IGetting zero all rows instead of replacing only blanks with zeros
A few comments/suggestions:
1. You don't need to put CALCULATE around those expressions. Just MAX() will work in this case.
2. If you project status only ever improves, your approach with MAX will work, but if project ever have setbacks and the progress values goes backwards, your measure will still just be getting the max progress.
3. The "+0" approach is useful sometimes. In this case, it is evaluating the measure for all the Date values in the Update table and always returning at least 0, which is why you have the extra rows. If you don't have any rows there, there will not be a date value either. Would it work to use the TD column from the Milestones table instead? You could then use a measure like this to return 0 if there are no rows
Status = IF(ISBLANK(COUNTROWS(Updates)), 0, MAX(Updates[Update]))
Regards,
Pat
Super Userahmadhatahet
You can try:
MAX All Zeros = MAX (update[update] ) + 0
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
ahmadhatahetThank you, this as same as mine.