Forum Discussion
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...
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!
Hi LYeo87 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.