英文:
Containsstring in dax cannot search the string
问题
我有一个表格，我想要对行数进行计数，但是公式不起作用。我已经尝试过通配符了。不确定我做错了什么。
该卡片显示为空白
资产行数 =
计数行数(
过滤(
'GL Account Group - GLACGRP',
包含字符串('GL Account Group - GLACGRP'[Account Group Name], "资产")
)
)
数据如下图所示：
英文:
I have a table in which I want to do a count of rows but the formula is not working. I have tried wildcards too. Not sure what am I doing wrong.
The card displays BLANK
Asset Rows =
COUNTROWS(
FILTER(
'GL Account Group - GLACGRP',
CONTAINSSTRING('GL Account Group - GLACGRP'[Account Group Name], "assets")
)
)
The data is as follows:
答案1
得分: 1
Your code is correct. Trim the column 3 and check. May be some extra spaces causing error.
英文:
Your code is correct. Trim the column 3 and check. May be some extra spaces causing error.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论