Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX SWITCH STATEMENT not working properly

Hello, I am just trying to make a mesure by using SWITCH statement. but it is not working properly. I don't know why. Here is my code. I feel like there is something wrong with SWITCH statement be...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    Based on my test and reasearch, I have added a filter in your [Construction Income (Budget)] measure and now it can show the correct result:

     

    Construction Income (Budget) = CALCULATE(SUM('Budget For Meters'[Budget]), FILTER(ALL('Budget For Meters'),'Budget For Meters'[Description] = "1.Construction Income"))

     

    Attached the modifed dummy file, please check it: Dummy.pbix

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Here you go.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

here's how SWITCH() is supposed to work for your scenario (there are other options too)

 

SWITCH( TRUE(),<first test>,"first result",<second test>,"second result",...,"alternative result")

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Actually, I gave you wrong code. This is right one.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      6 years ago

      You are using CALCULATE() without any filter context modifiers.  That means the calculation will only work on the current context of your visual which is very likely not what you want to do (and which doesn't really need Calculate).  What are you actually trying to calculate?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Sorry for late response. What do you mean by I am using CALCULATE () without any filter context modifiers? (Sorry again I am a beginner of Power BI.) Basically, I created this measure compare budget and actual like how much actual is different from budget and representing as percentage. The thing is, without SWITCH statement, my code is working. I got a number I want. However, when I add SWITCH statement, it is not working. I am not sure why this is happening.