Switch statement not working

[priyanath1988]

Perc_display =

   SWITCH (

      TRUE (),

      '_1'[Value]= 0.0 , "0%",

      '_1'[Value]= 0.05, "5%",

      '_1'[Value]= 0.10, "10%",

      '_1'[Value]= 0.15, "15%",

      '_1'[Value]= 0.20, "20%",

      '_1'[Value]= 0.25, "25%",

      '_1'[Value]= 0.30, "30%",

      '_1'[Value]= 0.35, "35%",

      '_1'[Value]= 0.40, "40%",

      '_1'[Value]= 0.45,"45%",

      '_1'[Value]= 0.50,"50%",

      '_1'[Value]= 0.55,"55%",

      '_1'[Value]= 0.60,"60%",

      '_1'[Value]= 0.65,"65%",

      '_1'[Value]= 0.70,"70%",

      '_1'[Value]= 0.75,"75%",

      '_1'[Value]= 0.80,"80%",

      '_1'[Value]= 0.85,"85%",

      '_1'[Value]= 0.90,"90%",

      '_1'[Value]= 0.95,"95%",

      '_1'[Value]= 1,"100%",

    "NOt"

)

but it is working for few cases only and I am getting result like below

Do you guys help me understand why it is happening?

Thanks 

[Ahmedx]

[priyanath1988]

I am still trying to understand why it's happening. however I have found a workaround to display % values.

As a workaround I duplicated the "Value" column , multiplies by 100 and concatenated with "%" symbol. this will be used only for display purpose. In this way I have a column for calculation and other for display.

Best

[priyanath1988]

@bharath_v  thank you for your response. I am generating values like below in the dax,

_1 = GENERATESERIES(0.05, 1.05, 0.05)

[bharath_v]

Hi @priyanath1988 

It could be that the actual values may be exactly equal to the condition.

If you have used precision to cut the source data to 2 decimal points then you may get result like this.

To overcome this, change the precision of the field in the source data itself by going to "Transform Data" and Transform.

Hope this helps!

If I answered your question then pls mark my post as "Accept it as the solution" and a kudo would be appreciated.