Switch formula doesn't work correctly

Question

Hi all,&nbsp;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 expected for the amounts, but the same formula used for the percentages, i only returning values for part of the rows, and not for all the rows in between as shown in table on the left.&nbsp;When not used in the template but directly to the financial descriptions, the actual% is giving correct amounts. But when I want to use it whith the template descriptions, something went wrong..&nbsp;&nbsp;This is the formula for the amounts that works fine:Selected Year Actuals = Var CurrentItem = SELECTEDVALUE('Template WV'[Omschrijving-normalized])RETURN SWITCH ( TRUE(),CurrentItem = "Omzet", DIVIDE([Omzet],1,0),CurrentItem = "Bedrijfsresultaat", DIVIDE([Bedrijfsresultaat],1,0),CurrentItem = "Operationele kosten", DIVIDE([OperationeleKosten],1,0),CurrentItem = "Brutowinst", DIVIDE([Brutowinst],1,0),CurrentItem = "Resultaat voor belasting", DIVIDE([Resultaat voor belasting],1,0),CurrentItem = "Nettoresultaat", DIVIDE([Nettoresultaat],1,0),CALCULATE( [Actuals] , FILTER( 'Financiele resultaten' , 'Financiele resultaten'[Omschrijving]= CurrentItem ) ) )&nbsp;&nbsp;And this is the second formula for the percentages that is NOT working as I want:Selected Year Actuals % = Var CurrentItem = SELECTEDVALUE('Template WV'[Omschrijving-normalized])RETURN SWITCH ( TRUE(),CurrentItem = "Omzet", DIVIDE([Omzet%],1,0),CurrentItem = "Bedrijfsresultaat", DIVIDE([Bedrijfsresultaat%],1,0),CurrentItem = "Operationele kosten", DIVIDE([OperationeleKosten%],1,0),CurrentItem = "Brutowinst", DIVIDE([Brutowinst%],1,0),CurrentItem = "Resultaat voor belasting", DIVIDE([ResultaatVoorBelasting%],1,0),CurrentItem = "Nettoresultaat", DIVIDE([Nettoresultaat%],1,0),CALCULATE( [Actuals%] , FILTER( 'Financiele resultaten' , 'Financiele resultaten'[Omschrijving]= CurrentItem ) ) )&nbsp;Both are exactly the same, so I don't know what is wrong? It would be great if somebody can help me!&nbsp;Many thanks,&nbsp;

anonymous · Answer

If I were you I would repair the measures or test this problem with only the properly working measures first. You will have to do this eventually and it would help in solving this problem.

amitchandak · Answer

MarieD , formula seems ok, 
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

maried · Answer

amitchandak&nbsp;How can i share the pbix file on this forum?&nbsp;&nbsp;

vivran22 · Answer

MarieD&nbsp;
&nbsp;
You may use One Drive/Google Drive/Drop box or similar options to share the file. Save the file in the shared location and post the link on this thread.
&nbsp;
Cheers!VivekBlog: vivran.in/my-blogConnect on LinkedInFollow on Twitter

maried · Answer

Hi,&nbsp;this is the link to the file:&nbsp;https://www.dropbox.com/s/igzsmi89cml4yq7/Versie%20Helpforum.pbix?dl=0&nbsp;It would be great if somebody could help me!thanks!

Forum Discussion

Switch formula doesn't work correctly

9 Replies

Related content

If formula

formula

DAX Formula Help

Total % not showing correctly

DAX Formula