Forum Discussion

NadeemAhamed's avatar
NadeemAhamed
Icon for Helper V rankHelper V
2 years ago

Avoiding #DIV/0! (inf) for calculated values

Dear All,  Greetings!   I have calculated measures which is perform division for two physical column from excel sheet.  We have some formula=IFERROR(A1/B1,0) in excel to avoid this #DIV/0! or inf...
Need Help
NadeemAhamed's avatar
NadeemAhamed
Icon for Helper V rankHelper V
2 years ago

Bcz i that column was have some formate and calculation so we have created measures for that, 

In that measures we have to avoid this error.

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

I went through your pbix file and I definetly think you can use divide function. Have you tried using it and if yes what is the error?