Change decimals in Rank measure

[chavanr]

Hi there,

Is it possible to have the calculation of Rank based on two decimal places?

please see example below:

column 1 is the measure by divide(column 3/column 4)

Rank is calculated based on the % .

I need the 91.71% should give rank 8 .

It is giving different rank because the % is different (upto 4 decimals)

can we have the rank calculated only for 2 decimal places?

Cheers,

[ryan_mayu]

@chavanr 

maybe you can try use round(measure,2) to make sure only contains to decimal. The 91.71% looks like the same, but actually they are different.

[chavanr]

yes, did that but it is still taking different rank

[ryan_mayu · Accepted solution]

@chavanr 

could you please share the sample data?

I did a test in PBI, please see attachmetn below

[chavanr]

Thanks @ryan_mayu  It works alright !!