Forum Discussion
Prob with infinite
Hi there!
Dividing by 0 will return "infinite" in Power BI using "/". What you should do is use DIVIDE function instead, where you can set an alternate result to return when dividing by zero.
The measure would look like this:
Vorschlag CT =IF(SUM('Sales invoices 2021/2022 (2)'[Quantity]) =0,BLANK(),DIVIDE(SUM('Sales invoices 2021/2022 (2)'[Quantity]) - 'Item'[Theoretischer Vorrat],SUM('Item'[Anz. / Paket])))Let me know if that helps!Please mark my previous answer as a solution and then procced to create a new post with your new question. This way we help other users find solutions to their problems more easily.
Hi there!
Dividing by 0 will return "infinite" in Power BI using "/". What you should do is use DIVIDE function instead, where you can set an alternate result to return when dividing by zero.
The measure would look like this:
Hi Pablo,
yes it works. Perfekt thx.
Maybe you can help me with another problem?
When I display the total sum of the measure, the result does not fit.
how can i solve this?
Please mark my previous answer as a solution and then procced to create a new post with your new question. This way we help other users find solutions to their problems more easily.
