Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

if error

hiii i was trying to calculate sla% based on priority but i am getting an error while using IFERROR function  
Need Help
Show and Tell
  • Anand24's avatar
    Anand24
    6 years ago

    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 !!!

Anand24's avatar
Anand24
Icon for Super User rankSuper User
6 years ago

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 !!!