Dynamically display decimal

[rolyzo]

I have the next column:

tblDesviacionMovil[NDecimal]

This column tells me that the parameter must show its value with N Decimal

for example:

Parameter                NDecimal

Parameter1              1

Parameter2              0

Parameter3              2

and I have another measure column

Real = SWITCH(MAX(tblDesviacionMovil[TipoCalculo]),
3, sumx(tblDesviacionMovil, (tblDesviacionMovil[RealOrigen] * tblDesviacionMovil[ProductoCartesiano2]) / sum(tblDesviacionMovil[ProductoCartesiano2])),
1, SUM(tblDesviacionMovil[RealOrigen]),
2, AVERAGE(tblDesviacionMovil[RealOrigen]) )

Now, I want to display this measue column (Real) in Table visual with the following form.

Parameter                Real

Parameter1              120.1

Parameter2                 321

Parameter3              235.85

I need to do this

Thanks for you help.

[Greg_Deckler]

Hmm, I'm not aware of a way to do that. You set the number of decimal places to show for a measure once per measure. Perhaps you could take the output of your formua and convert it to a string and then parse it to only the number of decimal places that you want?

[rolyzo · Accepted solution]

I use a formula and then the FORMAT function.

Thanks for everything.