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,
Please show the your final expected result.
The final output would be:
| ModelVersionID | Element Name |
| 100 | Built-in Bar |
| 101 | Door Frame (E) |
| 102 | Existing Wall 2 |
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
MaggieCommunity 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)
