Forum Discussion
Using a column of values with CONTAINSSTRING
I have the following DAX expression for a new calculated table: FILTER( 'Grid Data', AND( RELATED('Model'[Id]) = 68, OR( CONTAINSSTRING('Grid Data'[Family Name],"(E)"), CONTAINSSTRING('Gri...
Hi mlee
For 69, it contains "Rail, missing, generic" ,
| ModelId | Search terms |
| 68 | built |
| 68 | (E) |
| 69 | Rail |
| 69 | missing |
| 69 | generic |
69 corresponds to Model Version ID's of 102,
but the Element Name of 102 contains
"Built-in Bar,Existing Wall2, Carpeting",
we can't find any of "Rail, missing, generic" in "Built-in Bar,Existing Wall2, Carpeting"
why the final output is ?
| ModelVersionID | Element Name |
| 100 | Built-in Bar |
| 101 | Door Frame (E) |
| 102 | Existing Wall 2 |
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You are correct v-juanli-msft . I made a mistake when I pasted in the final output.
The corrected final output would be:
| ModelVersionID | Element Name |
| 100 | Built-in Bar |
| 101 | Door Frame (E) |