Forum Discussion

KateDANI's avatar
KateDANI
Frequent Visitor
2 years ago
Solved

DAX New Measure, returning Infinity and IFERROR not working. Help please

I have created a new measure to return a ratio but when the answer is zero I am getting Infinity. I have done research and can see I could use the IFERROR retuen blank but when I do the following code I keep getting errors. Can anyone help please

 

 

  • ERD's avatar
    ERD
    2 years ago

    KateDANI , you have issues with the formatting. 

    IFERROR ( SUM ( Table[Column] )  / SUM ( Table[Column] ), BLANK() )

2 Replies

  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    2 years ago

    KateDANI , you have issues with the formatting. 

    IFERROR ( SUM ( Table[Column] )  / SUM ( Table[Column] ), BLANK() )