cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
harsha1234 Frequent Visitor
Frequent Visitor

Rounding the value of a measure

Hi all,

 

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!!

H

1 ACCEPTED SOLUTION

Accepted Solutions
synergised Member
Member

Re: Rounding the value of a measure

Visual formating is under the Modeling tab.

 

.85 then apply the % and set the decimal places.. in your case to 0.

 

modeling.png

2 REPLIES 2
synergised Member
Member

Re: Rounding the value of a measure

Visual formating is under the Modeling tab.

 

.85 then apply the % and set the decimal places.. in your case to 0.

 

modeling.png

BKirsch12 Member
Member

Re: Rounding the value of a measure

Select the measure on the fields pane on the right. Then under modeling, use thes formatting section:BI Menu.PNG

 

 

You may need to adjust your measure fro 85 to display as 85% as opposed to 8500%.