power bi中措施的效率 [英] Efficiency of measures in power bi

问题描述

假设你有一张桌子.

OrderNumber, OrderDate, City, & Sales 

Sales 字段提供给您.不需要计算它.将此数据引入 Power BI 时，假设您要按 City 分析 Sales(以表格格式).您可以直接将这两个字段拖到表格中.无需创建度量.

The Sales field is given to you. No need to calculate it. When you bring in this data into Power BI, say you want to analyze Sales by City (in a table format). You can just straight away drag the two fields into the table. No need to create a measure.

现在，假设您创建了一个度量.

So now, suppose you created a measure, though.

Total Sales = Sum(Sales).

在这种情况下，它有什么优势吗?

Is there any advantage to it, in this scenario?

使用效率更高吗:City、Total Sales比使用:City, Sales

Is it more efficient to use: City, Total Sales than it is to use: City, Sales

两者都显示相同的信息.

Both display the same information.

推荐答案

有人告诉我，总是创建明确的度量是好的，而且度量更有效.天气是对是错，我不知道，但从政策的角度来看，这是一个好主意，因为措施确实可以保护您免受列名更改的影响.一般来说，我认为我可以制定一个经验法则来始终定义您想要明确报告的任何措施......但上面的答案也可能是正确的......堆栈交换不允许您选择多个答案....

I was told that it is good to always create explicit measures, and that measures are more efficient. Weather right or wrong, I don't know, but from perspective of policy, it is a good idea, since measures do protect you from column name changes. In general, I think I can just make a rule of thumb to always define any measures that you want to report on explicitly.... BUT the answer above could also be correct... stack exchange doesn't let you choose multiple answers....

这篇关于power bi中措施的效率的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！