Forum Discussion

LYeo87's avatar
LYeo87
Helper II
1 year ago
Solved

% result errors using dax

Hello,   Im trying to gain a % of audit items when the audit item result is 'complaint' - it works fine when i use the full data set. But as soon as I use a slicer it through the figures. Dax us...
Need Help
Show and Tell
Tips and Tricks
  • wardy912's avatar
    wardy912
    1 year ago

    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!

wardy912's avatar
wardy912
Super User
1 year ago

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!