Power Bi DAX十进制舍入 [英] Power Bi DAX Decimal Rounding

问题描述

我使用联接表创建了一个量度，以向我显示某物的比率.我遇到的问题是我的值总是四舍五入.这是一个非常有限的比率，需要至少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 函数会将其四舍五入到小数点后四位，但是您想要对其进行 format 格式化显示更多的小数位.

The ROUND function does round it to 4 decimal places but what you want is to format it to show more decimal places.

选择度量，然后转到顶部的建模表.格式部分，可让您更改度量显示的格式.

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屋！