即使我选中“不汇总”，“值”列也会计数或汇总。 Power BI桌面 [英] Value column counts or Summarizes even if I checked "Dont Summarize" Power BI Desktop

问题描述

目标是创建一个显示一年中每个月的预算vs溢价的图像；
这样的东西：

我建立了保险费表和部门表之间的关系。它没有给我任何错误，所以我假设一切都很好。

在图表上，我需要总和但不是预算总和。
但是，当我将预算放在柱形图上时，它会进行总结。我检查了不汇总，但仍然汇总了两个计数值。

汇总了高级值，这很好，这就是我需要的。但是预算值我不需要汇总或计算。

有可能吗？
为什么这样做？

.PIBX文件位于此处：

PS如果您可以不将 Premium 放在同一张图表中，则可以为预算创建一个度量，然后然后将 InsurType 作为 Legend 放入图表中以分隔类型。 （只有当您有一个 Value 时，传奇才可用）

The goal is to create a visual that shows Budget vs Premium for each month in a year; Something like that:

I established relationship between Premiums table and Divisions table. It didnt give me any error, so I'm assuming everything is fine.

On a chart I need SUM of premium but NOT SUM of Budget. But when I put Budget on a column chart it summarizes it. I checked "Do not summarize" but it still, either summarize either count value.

Premium value summarized which is fine, that is what I need. But Budget value I do not need summarize or count.

Is it possible? Why it acting that way?

.PIBX file is available here: https://www.dropbox.com/s/6kvh7quylcirj0o/PremiumByDivisions1.pbix?dl=0

解决方案

You have 6 InsurType and hence 6 Budget for each month.

That's why Power BI has to enforce a summarization to the Budget column when it's put in the Value of the chart.

---

To display Premium alongside Budget for each InsurType, you'll have to create a measure for each InsurType and add them to the chart:

e.g.

Commercial Auto Budget = 
CALCULATE(
    FIRSTNONBLANK('Divisions 2'[Budget], 0),
    'Divisions 2'[InsurType] = "Commercial Auto"
)

Worker's Comp Budget = 
CALCULATE(
    FIRSTNONBLANK('Divisions 2'[Budget], 0),
    'Divisions 2'[InsurType] = "Worker's Comp"
)

Specialty Casualty Budget = 
CALCULATE(
    FIRSTNONBLANK('Divisions 2'[Budget], 0),
    'Divisions 2'[InsurType] = "Specialty Casualty"
)

...

You also have to change the Cross filter direction between Premium and Division 2 table to Both so that the Date filter can be passed to the Division 2 table.

Results:

P.S. If you're OK with not putting Premium in the same chart, then you can just create one measure for Budget and then put in InsurType as Legend to the chart to separate the types. (Legend is only usable when you have one Value)

这篇关于即使我选中“不汇总”，“值”列也会计数或汇总。 Power BI桌面的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！