Forum Discussion

yodha's avatar
yodha
Icon for Helper IV rankHelper IV
7 years ago
Solved

IF statement in Power BI

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.

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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
)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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
)