topic Re: Format Calculation as Percentage in DAX Commands and Tips

Format Calculation as Percentage

Belindah — Mon, 17 Jun 2024 20:04:26 GMT

I want to format the result of the following calculation as a percentage. I have tried using the FORMAT function, but I can't make it work. Any help is greatly appreciated!

Switch Complete = CALCULATE(SUM('table 4'[Switches]),'table 4'[Complete] = "Yes")/(SUM('table 4'[Switches])

)

Re: Format Calculation as Percentage

Greg_Deckler — Mon, 17 Jun 2024 20:26:04 GMT

Belindah Don't use FORMAT as that will turn it into text. Click on the measure in the Data pane while in the Report view. In the ribbon, find the Formatting section and click on the % icon.

Re: Format Calculation as Percentage

Anonymous — Thu, 20 Jun 2024 05:37:47 GMT

Hi Belindah,

You can also use field format string to change the field display format without effect the raw field values.

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Regards,
Xiaoxin Sheng