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.

lbendlin's avatar
lbendlin
Super User
6 years ago

use daxformatter.com to put your formula into a readable format, and maybe find out where your logic breaks down.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Here you go.

  • lbendlin's avatar
    lbendlin
    Super 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
        Super 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?