如何从Power BI桌面中的度量获取平均值 [英] How to get average from a measure in Power BI desktop

问题描述

在我的数据源中，有引用和提交列。

In my data source I have column Quoted and Submitted.

将 Sum（报价）除以 SUM（已提交）为我们提供了要报价的子项目的比率。

Dividing the Sum(Quoted) by SUM(Submitted) gives us Sub to Quote ratio.

因此，我创建了一个将报价/已提交划分的度量。 / p>

So I have created a measure that divides Quoted/Submitted.

Sub to Quote = DIVIDE([Total Quoted], [Total Submitted])

现在，我如何简单地获得该比率的平均值？

Now, how can I simply have Average of that ratio?

因此，我需要查看 9％ > 8.18％

So instead of 9%, I need to see 8.18%

。 PBIX 文件可在此处访问：

https://www.dropbox.com/s /ug932qjju7zahfs/ClearanceDateNewWithCatalytic1.pbix?dl=0

推荐答案

我会尝试这种方法s：

Sub to Quote =
AVERAGEX(
    SUMMARIZE(dim_Date,
        dim_Date[Qtr Year],
        "Average", DIVIDE( [Total Quoted], [Total Submitted] )
    ),
    [Average]
)

这汇总了您的表格，以获取每个季度的平均值，然后将这些平均值取平均值。

This summarizes your table to get the average for each quarter and then averages those averages.

注意：这将返回 8.15％而不是 8.18％。我想这只是四舍五入而已。

Note: This returns 8.15% rather than 8.18%. I'm guessing this is just a rounding difference though.

这篇关于如何从Power BI桌面中的度量获取平均值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！