Forum Discussion
if error
hiii i was trying to calculate sla% based on priority but i am getting an error while using IFERROR function
Hi Anonymous ,
IFERROR Dax function needs 2 arguments to be passed while you have provided just 1 argument.
Syntax: IFERROR(Value1, Alternate Value if value1 results to error)
If MitigationHit/MitigationCount results to error, what value should be returned it missing in you formula. Please include another arugument and this should work fine.
Reference Link: https://docs.microsoft.com/en-us/dax/iferror-function-dax#example
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
You should read the error message. You should also investigate the DIVIDE function as an alternative