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 cod...
  • ERD's avatar
    ERD
    2 years ago

    KateDANI , you have issues with the formatting. 

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

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() )

KateDANI's avatar
KateDANI
Frequent Visitor
2 years ago

FAB, THANK YOU