我试图在文本字符串中找到一个特定的值,并计算具有该值的行数。但是,我编写的每个DAX公式都返回1。
字符串示例AB;AB-Assessment;MyComponent;新员工培训;ID: 1234;筛选
公式示例:
ComponentTeam_MyComponent =
CALCULATE(COUNTROWS(
FILTER('MyTable',
FIND("MyComponent", 'MyTable'[Tags],,0)>0)))
ComponentTeam_MyComponent =
CALCULATE(
COUNTROWS('MyTable'),
SEARCH("MyComponent", 'MyTable'[Tags],,0)>0)
您尝试过CONTAINSSTRING吗?
ComponentTeam_MyComponent =
COUNTROWS (
FILTER (
'MyTable',
CONTAINSSTRING ( 'MyTable'[Tags], "MyComponent" )
)
)