Adding a "%" to a one cell of a numeric column

[Anonymous]

Hi!

I have a numeric measure like this:

=CALCULATE([FIN_Import];PBI_REP_FIN[Tipo de valor_Clave]="10")

and for several rows I want to add a "%" to the right.

I've tried CONCATENATE (Like following, but obviously I try to put a text into a number cell), FORMAT() or CONVERT(), but it doesn't work:

FIN_R = IF(SEARCH("% ";SELECTEDVALUE(M_Account_PL_Str[PL5]);1;0);CONCATENATE(CALCULATE([FIN_Import];PBI_REP_FIN[Tipo de valor_Clave]="10");"%");CALCULATE([FIN_Import];PBI_REP_FIN[Tipo de valor_Clave]="10"))

Is it possible?

Thanks in adavance!

[v-yuta-msft]

@Anonymous ,

You may modify your measure like below:

FIN_R =
IF (
    SEARCH ( "% "; SELECTEDVALUE ( M_Account_PL_Str[PL5] ); 1; 0 );
    CONCATENATE (
        CALCULATE (
            [FIN_Import];
            FILTER ( ALL ( PBI_REP_FIN ); PBI_REP_FIN[Tipo de valor_Clave] = "10" )
        );
        "%"
    );
    CALCULATE (
        [FIN_Import];
        FILTER ( ALL ( PBI_REP_FIN ); PBI_REP_FIN[Tipo de valor_Clave] = "10" )
    )
)

Community Support Team _ Jimmy Tao

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

[Anonymous]

Hello!

Firstly, thank you for your response. But it does not work. It returns the same error:

"You can not convert the XX value from text to Numeric/date"