Forum Discussion

edcdcpowerbi's avatar
edcdcpowerbi
Helper I
4 years ago
Solved

Nested IF statement

I am needing to add a third if statement below, which replaces blank values with a 0.  On its own it works fine, the other two if statements work without this third being added.    How do i correc...
  • goncalogeraldes's avatar
    goncalogeraldes
    4 years ago

    The way DAX handles BLANKS can be somewhat confusing so in this case it can be something related to DAX never considering the value to be blank and evaluating it as FALSE everytime. A possible workaround can be:

     

    SWITCH(
TRUE(),
SliderValue = BLANK(), 0,
SliderValue = 0, Actual,
SliderValue > 0, ProjRR,
SliderValue
)

     

    Check out this article as it may help you in this case or in a similar one in the future!

     

    Hope this answer solves your problem! If you need any additional help please tag me in your reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
    Thanks!

    Best regards,
    Gonçalo Geraldes

edcdcpowerbi's avatar
edcdcpowerbi
Helper I
4 years ago

Thanks for the help goncalogeraldes. i did try to remove SliderValue, but to no avail. 

I did try the switch statement but it return True, instead of the values i wanted, where have i gone wrong? 

 

SWITCH(SliderValue,
IF(ISBLANK(SliderValue),0,SliderValue),
SliderValue = 0, Actual,
SliderValue>0,ProjRR
)

goncalogeraldes's avatar
goncalogeraldes
Super User
4 years ago

edcdcpowerbitry this! 

SWITCH(
TRUE(),
ISBLANK(SliderValue),0,
SliderValue = 0, Actual,
SliderValue > 0,ProjRR,
SliderValue
)

 

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

    • goncalogeraldes's avatar
      goncalogeraldes
      Super User
      4 years ago

      edcdcpowerbi please send the full formula then. What is the SliderValue?

      • edcdcpowerbi's avatar
        edcdcpowerbi
        Helper I
        4 years ago

        sure, here it is goncalogeraldes 

         

        VAR Actual = [Recycling Rate (PET)]
        VAR AverageR = [Median Recycling Rate (PET)]
        VAR SliderValue = [PETRecyclingRateOverride Value]
        VAR ProjRR =
        IF( SliderValue > 0, DIVIDE( SliderValue, 100, 0 ), Actual ) //var AverageRR = IF (SliderValue > 0, DIVIDE(SliderValue,100,0), AverageR)
        RETURN
        //IF ( SELECTEDVALUE (Jurisdiction[DRS Status]) = "Existing DRS" , ProjRR, AverageRR)

        SWITCH(
        TRUE(),
        ISBLANK(SliderValue),0,
        SliderValue = 0, Actual,
        SliderValue > 0,ProjRR,
        SliderValue
        )