percentages and numeric values ​​in one table

[gz]

Hi, I have percentages and numeric values ​​in one table. How can I set it in measures so that the format will be % and accounting.

[Sebastian_Dec]

Hi, @gz in Table -> Data -> change Number formatting to Number and choose formatting to procent.

[MayilVahanan · Accepted solution]

Hi

In the expression itself, you can declare the formatting using num() function and set measure number formatting as "Measure expression"

Ex: If(Dim1 = 'A', Num(Sum(Sales), '#,##0'), if(Dim1  = 'B', Num(Sum(Sales)/Sum(Total Sales), '#,##0.##%'))

[gz]

hi, this will doesen't work because i have in one table % and amount value

[gz]

doesn't work, my measure expression is "Avg(wartosci)"

[gz]

in measure expression i have 

If([Nazwa metryki] = 'KR: Na koniec 2023 nowe umowy eSkonta wygenerują 2,2 mln przychodu',Num(Avg(wartosci), '#,##0'),Num(Avg(wartosci), '#,##0.##%'))

but in table 

[MayilVahanan · Accepted solution]

Hi

Can you set the Expression formatting as "Measure expression" instead of Default