Power Bi DAX 十进制舍入 [英] Power Bi DAX Decimal Rounding
问题描述
我使用连接表创建了一个衡量标准,以向我显示某事的比率.我遇到的问题是我的值的四舍五入总是2位.这是一个非常有限的速率,至少需要 3 个舍入位.
I created a measure using joined tables to show me a rate of something. The problem I'm having is that the rounding of my value is always 2 places. It's a very finite rate that requires at least 3 rounding places.
我尝试过使用 ROUND
,但这不起作用.我已经包含了我的视觉和测量的屏幕截图.
I've tried using ROUND
, but that doesn't work. I've included a screen cap of my visual and my measure.
推荐答案
ROUND
函数会将其四舍五入到小数点后 4 位,但您想要格式化它显示更多小数位.
The ROUND
function does round it to 4 decimal places but what you want is to format it to show more decimal places.
选择您的度量并转到顶部的建模表.Formatting 部分可让您更改度量用于显示的格式.
Select your measure and go to the Modeling table at the top. There's a Formatting section that will allow you to change the format the measure uses to display.
这篇关于Power Bi DAX 十进制舍入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!