using more than 4 dax formulas in PBI

[Anonymous]

Hi PBI users, 

I have a question about using multiple dax formulas. I am actually wanted to use a divide function but some values in my denominator has no values so I get a answer as infinity. In order to get rid of infinity I used this below formula from DAX documentation

Profit Margin = IF( OR( ISBLANK([Sales]), [Sales] == 0 ), BLANK(), [Profit] / [Sales] ) , but the formula shows input errors 

tryone = if(OR(ISBLANK(['Intl AOP SSA'[2022 AOP]]),['Intl AOP SSA'[2022 AOP]] == 0),BLANK(), [Total Netsales]/['Intl AOP SSA'[2022 AOP]]))))). could anyone give me suggestion?

[rsbin · Accepted solution]

@Anonymous,

The Divide function has 3 parameters:

DIVIDE(<numerator>, <denominator> [,<alternateresult>])

The last parameter is used to take care of any errors.

Please review this link for more details:

https://learn.microsoft.com/en-us/dax/divide-function-dax

This should resolve your "infinity" issues.

[AnastasiaS]

Hello @Anonymous 

Have you tried using the DIVIDE function? DIVIDE(<numerator>, <denominator> [,<alternateresult>])

It handles errors in the following way : The DIVIDE function was designed to automatically handle division by zero cases. If an alternate result is not passed in, and the denominator is zero or BLANK, the function returns BLANK. When an alternate result is passed in, it's returned instead of BLANK.

Source : https://learn.microsoft.com/en-us/dax/best-practices/dax-divide-function-operator