Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Division by Zero fix changing visuals

I have a calculation on two measures, SUM('QGenda Compliance'[CompliantClockIn/Out])/SUM('QGenda Compliance'[RequiredClockIn/Out]) resulting in NaN because the denominator can be 0.  I've been trying...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    According to my understand , you want to diaplay the measure result based on Months selected in Slicer , right?

    You could use the following formula:

    Overall Compliance =
IF (
    'QGenda Compliance'[RequiredClockIn/Out] = 0,
    0,
    'QGenda Compliance'[CompliantClockIn/Out] / 'QGenda Compliance'[RequiredClockIn/Out]
)

    Or use DIVIDE()

    Overall Compliance =
DIVIDE (
    'QGenda Compliance'[CompliantClockIn/Out],
    'QGenda Compliance'[RequiredClockIn/Out]
)

    The matrix visual and line chart look like this:

     

    Here is the pbix file.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.

    If not, please upload some insensitive data samples and expected output.

     

    Best Regards,

    Eyelyn Qin