Division by Zero fix changing visuals

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