英文:
Power BI - DAX - Cannot be Converted to a Scalar Value
问题
代码部分不翻译，以下是已翻译的内容：
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.（该表达式涉及多个列。多个列无法转换为标量值。）
I want this to do more, but I have it stripped down to the bare minimum requirements for troubleshooting. I've tried all kinds of tricks, but nothing seems to be working.（我想让这个做更多的事情，但我已经将其简化为故障排除的最低要求。我尝试了各种技巧，但似乎没有任何效果。）
Summarize = SUMMARIZE(
MailboxStatisticsHistorical,
MailboxStatisticsHistorical[Date],
"Distinct", DISTINCTCOUNT(MailboxStatisticsHistorical[Identity])
)
英文:
I think there's nothing wrong with this, but PBI disagrees:
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
I want this to do more, but I have it stripped down to the bare minimum requirements for troubleshooting. I've tried all kinds of tricks, but nothing seems to be working.
Summarize = SUMMARIZE(
MailboxStatisticsHistorical,
MailboxStatisticsHistorical[Date],
"Distinct", DISTINCTCOUNT(MailboxStatisticsHistorical[Identity])
)
答案1
得分: 2
SUMMARIZE 返回一个计算表。您不能将其分配给一个度量值。 (度量值期望标量结果。) 请改用计算表格用户界面。
英文:
SUMMARIZE returns a calculated table. You can't assign it to a measure. (Measures expect scalar results.) Use the Calculated Table UI instead.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论