Percent measure in switch function

[kasife]

Hi Guys,

My measure varSelecao = 2, [_EP]*100 is of the percentage type, but in my visual it does not appear as a percentage. Is there any way to adjust this?

Medida Switch Repasse (qtde) = 
VAR varSelecao = SELECTEDVALUE(Tabela[ID])
RETURN
SWITCH(
    TRUE(),
    varSelecao = 1, [_IPC],
    varSelecao = 2, [_EP]*100,
    varSelecao = 3, [_IPG]
)

[Anonymous · Accepted solution]

Hi @kasife ,

Here I suggest you to refer to below solved post which has similar issue like your.

For reference:

SWITCH or VAR Function for multi-data types in single table for rows and columns?

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HassanAshas]

Are you using Medida Switch Repasse (qtde)  in your visual?
If yes, then you need to make this Measure also Percentage type, and that will fix your issue. 

[kasife]

@HassanAshas 

Within the Switch, only this measure is a percentage, the others are not. If I change the type, they will all be as a percentage.