Forum Discussion

MarieD's avatar
MarieD
Icon for Helper I rankHelper I
6 years ago

Switch formula doesn't work correctly

Hi all,   I'm currently working on a financial report with a template. I want to make a difference in amount in euro's and the percentages. For both I use a switch formula which is working as expe...
MarieD's avatar
MarieD
Icon for Helper I rankHelper I
6 years ago

amitchandak

 

How can i share the pbix file on this forum?

 

 

    • bertalan_ronai's avatar
      bertalan_ronai
      Icon for Advocate I rankAdvocate I
      6 years ago

      Omzet% = DIVIDE([Omzet],[Omzet]) -this measure looks strange. Are you sure it is good?

    • vivran22's avatar
      vivran22
      Icon for Community Champion rankCommunity Champion
      6 years ago

      MarieD 

       

      The way I see it, your all calculation is coming from the table marked in red, and you are filtering it using the table marked in blue

      Since there is no relationship between them, wherever you have defined the filter context in your measure, it is giving you the result, otherwise it is returning blank.

       

      So, either we establish a relationship, then we can get the two tables to interact or we modify our DAX.

       

      PS: I believe there is a significant scope of improving the model and the meausres. For instance, why we are dividing the meausres by 1?

       

      Cheers!
      Vivek

      If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
      If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

      Blog: vivran.in/my-blog
      Connect on LinkedIn
      Follow on Twitter

      • MarieD's avatar
        MarieD
        Icon for Helper I rankHelper I
        6 years ago

        Hi,

         

        I know I still have to look into the measures, they are not completely correct yet, but I think that should not have impact on wheather the SWITCH formula is giving any results or not? For some rows it is not giving back anything at all?

         

        I know there is not a relationship between those 2 tables, but that is also the case for the first formula, and that one is working fine. On another topic about financial reports with a template, it was told not to link the 2 tables.. So that's how I got it working for the first one, and i tried to set up the 2nd one exaxctly the same, but I can't get that one working.

         

        Would your advise be to change the relationships then?