Why do my SWITCH measure results have a long number despite selecting 2 decimals?

[ale_BI]

To give a bit more info, this is the main part of how I insert the values into the SWITCH measure. Please note it's a very shortened version, but includes the two main types of values (with and without additional text)

var delta_etc_pfe_perc =

IF( LEN([Δ ETC vs PFE %]) > 0, [Δ ETC vs PFE %], 0 )

var result = SWITCH( TRUE(), /* Metric = Days */
    metrics = 1 && selected_column_1 = "Planned", [Frc Days],
    metrics = 1 && selected_column_1 = "Δ ETC vs PFE", [Δ ETC vs PFE] & " (" & delta_etc_pfe_perc & ")",

So in this case, my value Delta ETC vs PFE is numerical, but the variable I insert after is text because SWITCH doesn't allow me to insert numerical percentage variables, as they will become reformatted as non percentage. So I format as text the measure as I calculate it on its own as follows: FORMAT(Result, "0.00%") and then here make that if() call on it

As you can see I also added a measure to conditionally colour only some of the values, and I just want to state beforehand that changing that won't affect the result.

Why do my SWITCH measure results look like this? I already fixed the decimal number to 2 values. It only happens for those rows where I stated that it should give me both the result of an operation and then another one within parenthesis. But both of those values I also fixed to 2 decimals only

[andhiii079845 · Accepted solution]

Can you try something like:

var result = SWITCH( TRUE(), /* Metric = Days */
    metrics = 1 && selected_column_1 = "Planned", round([Frc Days],2),
    metrics = 1 && selected_column_1 = "Δ ETC vs PFE", round([Δ ETC vs PFE],2) & " (" & delta_etc_pfe_perc & ")",

[ale_BI]

This got the job done precisely, thank you!