英文:
Can't convert text type value into True/False in Power BI using DAX
问题
我有一个名为ProyectoID的列，其中包含唯一记录。此列的类型为文本。错误消息说：“无法将类型为文本的“Talbot”转换为类型True/False”。这很奇怪，因为在添加Talbot之前，它运行得很完美。
英文:
I have an column called ProyectoID that holds unique records. This column is type text. The error says: "Can't convert "Talbot" of type Text into type True/False"
This is wierd considering that before Talbot was added, it worked perfectly.
答案1
得分: 1
以下是翻译好的部分：
一般的Calculated Column解决方案如下：
=
VAR ThisID = 'Table'[ID]
RETURN
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER (
'Table',
'Table'[ID] = ThisID
)
)
英文:
The generalized solution for a Calculated Column would be:
=
VAR ThisID = 'Table'[ID]
RETURN
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER (
'Table',
'Table'[ID] = ThisID
)
)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论