IF statement in Power BI

[yodha]

Hi,

i have data like this in my report,

and i need to write DAX/IF statement in power bi, which is similar to below formula.

if(([OVER]+[LOW]+[RIGHT]) <> 0) then ([RIGHT]/([OVER]+[LOW]+[RIGHT])) else null AS CORRECTSTOCK

(this formula i used in cognos)

Is it possible to write a formula like this in power bi? (result should be same as cognos formula)

Thanks in Advance.

[Anonymous · Accepted solution]

You can try this measure

Measure=
VAR __Over= SUM( table[over])
VAR __LOW = SUM( table[low])
VAR __Right = SUM( table[right])

VAR __TotalOLR = __Over+__LOW+__Right

VAR __IfTrue = 
    DIVIDE(
        __RIGHT,
        __TotalOLR

VAR __IfFalse= SUM ( table[CorrectStock])
RETURN

IF(
    __TotalOLR <> 0, __IfTrue, __IfFalse
)

[yodha]

Thank you so much.