I am trying to create a card with the percent of completions, and I'd like to round to the nearest whole number.
This is what I have right now:
Percent Complete = ROUND(DIVIDE('table'[completed],'table'[alle])*100,0)
After using this measure, I get for example: 85.00
How I can I get rid of the 0's at the end and if possible put a '%' sign after the value? So I'd like it to read: 85%
Thanks in advance!!
Solved! Go to Solution.
Select the measure on the fields pane on the right. Then under modeling, use thes formatting section:
You may need to adjust your measure fro 85 to display as 85% as opposed to 8500%.