How to change decimal places?

Hi Zaky

Currently your measure is returning a text value.

I would recommend that you adjust the measure so that it returns a number rather than text, and change its number format to percentage with two decimal places.

1. Rewrite your measure as follows:
   

   Response Performance percentage =
   [Response Met] / [Response Total]

   Note that I have removed the table names you had in front of the measures [Response Met] and [Response Total] as it is considered best practice to refer to measures without table names (to distinguish them from column references).
   
   
2. Select the Response Performance percentage measure in the field list, then on the ribbon Modelling tab, in the formatting section, choose Format: Percentage and 2 decimal places. You can also do this in the new Modelling view.
3. Now the measure should be formatted correctly wherever it is displayed, and since it is now a number it can be used in any visual expecting a number and will be sortable.

Regards,

Owen