Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to Solution.
could you please share the sample data?
I did a test in PBI, please see attachmetn below
Proud to be a Super User!
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.
Proud to be a Super User!
yes, did that but it is still taking different rank
could you please share the sample data?
I did a test in PBI, please see attachmetn below
Proud to be a Super User!
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |