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 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.