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

查看:41
本文介绍了Power Bi DAX 十进制舍入的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我使用连接表创建了一个衡量标准,以向我显示某事的比率.我遇到的问题是我的值的四舍五入总是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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆