topic IF statement in Power BI in DAX Commands and Tips

IF statement in Power BI

yodha — Thu, 22 Aug 2019 18:49:40 GMT

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.

Re: IF statement in Power BI

Anonymous — Thu, 22 Aug 2019 20:24:51 GMT

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
)

Re: IF statement in Power BI

yodha — Fri, 23 Aug 2019 05:34:34 GMT

Thank you so much.