Forum Discussion
Impactful IndividualMeasure help on decimal point
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
3 Replies
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
vjnvinodFormatting 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
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
