Replace 'No number' with a 0 in a sumx measure

[MRensenSDR]

Hi there!

Is it possible to replace the following "no number" value with a zero? 

I am using this DAX formula in the measure (third column)

Gemiddeld gecalculeerd uurloon = SUMX('Projectenbeheer', (('Projectenbeheer'[Kosten gecalculeerde uren] / 'Projectenbeheer'[Aantal uur gecalculeerd])))

Because 0 can't be divided by 0 I get this "no number" value returned. Because of these rows the total at the bottom isn't working. Does anyone perhaps know how to avoid this issue? Thanks!

[DataZoe · Accepted solution]

@MRensenSDR You can resolve this I think with using the DIVIDE DAX funciton:

Gemiddeld gecalculeerd uurloon =
SUMX (
    'Projectenbeheer',
    DIVIDE (
        'Projectenbeheer'[Kosten gecalculeerde uren],
        'Projectenbeheer'[Aantal uur gecalculeerd],
        0
    )
)

[sayaliredij · Accepted solution]

HI,

Instead of '/' sign you can use DIVIDE function which handles 0 divider out of the box

Thanks,

Sayali 

If this post helps, then please consider Accept it as the solution to help others find it more quickly.

[MRensenSDR]

Thanks for all the quick replies! I should've known this... Thanks for all the quick help!

[jdbuchanan71 · Accepted solution]

@MRensenSDR 

Try it with a DIVIDE and 0 for the 3rd condition.

Gemiddeld gecalculeerd uurloon =
SUMX (
    'Projectenbeheer',
    DIVIDE (
        'Projectenbeheer'[Kosten gecalculeerde uren],
        'Projectenbeheer'[Aantal uur gecalculeerd],
        0
    )
)

[sayaliredij · Accepted solution]

HI,

Instead of '/' sign you can use DIVIDE function which handles 0 divider out of the box

Thanks,

Sayali 

If this post helps, then please consider Accept it as the solution to help others find it more quickly.

[DataZoe · Accepted solution]

@MRensenSDR You can resolve this I think with using the DIVIDE DAX funciton:

Gemiddeld gecalculeerd uurloon =
SUMX (
    'Projectenbeheer',
    DIVIDE (
        'Projectenbeheer'[Kosten gecalculeerde uren],
        'Projectenbeheer'[Aantal uur gecalculeerd],
        0
    )
)