% result errors using dax

Hi LYeo87 

 It looks like you're only removing filters from the audit item result column, so other slicers will be changing the result. Try this:

% Compliant = 
DIVIDE(
    CALCULATE(
        DISTINCTCOUNT('Dynamics - Pbi HSE_Audit_Inspections_LC'[Audit Item ID]),
        'Dynamics - Pbi HSE_Audit_Inspections_LC'[Audit Item Result] = "Compliant"
    ),
    DISTINCTCOUNT('Dynamics - Pbi HSE_Audit_Inspections_LC'[Audit Item ID])
)

 I hope this helps, please give a thumbs up and mark as solved if it does, thanks!