Used below DAX to format set of numbers, inorder to show percentage as percentage, number as numbers.
Go to Solution.
The FORMAT() syntax always converts the value to string. So if your aim is to make calculations it is not possible to use FORMAT().To my knowledge you will not be able to mix percentage with number formatting while still maintaining numeric format on your column/measure.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.