Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Divide function with inifity result issue

Hi guys,   I have been facing the Infinity issue when I have to divide by 0. This is the scenario, I have two columns one Original Qty and another one Updated Qty. I need to divide these two column...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Anonymous 
    To solve this issue with pq you can use an if statement like :

    Dax dive function knows to deal with zeroes automatically 

    pbix is attached
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    What is the error message?
    Try this formula on my sample and share the link to the pbix...

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ritaf1983  thank you for you reply.

 

I was testing the solution but for some reason I cant use it, please see the print below:

Am I doing something wrong?

 

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

What is the error message?
Try this formula on my sample and share the link to the pbix...

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I cant Press OK. You can see the red line or the red square on the box, meaning the syntax its not correct or not accepted?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Found the reason, I had the IF capitalize. Thats a dumb error 

    Thank you