Measure help on decimal point

[vjnvinod]

Dear community,

Below is my measure to calculate Margin %,  this is by default coming in 2 decimal point.

Can you help in tweaking this, so my output comes in 1 decimal point?

Margin% = IF(SUM(Inbound[NER_FYTD_Constant])=0,0,SUM(Inbound[MarginFYTD_Constant])/SUM((Inbound[NER_FYTD_Constant])))*100

[Data_Cornering]

If Formatting in Modeling tab does not do the thing, then try to add FORMAT function https://msdn.microsoft.com/en-us/query-bi/dax/format-function-dax

[vjnvinod]

@Data_Cornering

Formatting in modelling doesn't helps..

Can you help to create that format function in my measure?

Margin% = IF(SUM(Inbound[NER_FYTD_Constant])=0,0,SUM(Inbound[MarginFYTD_Constant])/SUM((Inbound[NER_FYTD_Constant])))*100

[v-shex-msft]

HI @vjnvinod,

In fact, you can direct modify decimal place on format table.
Choose your measure and click on format tab, then you'll find the property to modify displayed decimal place:

Regards,

Xiaoxin Sheng