Forum Discussion
CliffordAP
Helper II
3 years agoDAX Studio - DMV Queries - Where LIKE Condition Expression
Hello all! I am exploring this ability in Dax Studio to query measures by their names and expressions via the 'DMV' tab: I have a question about how to query the measures with these objects. ...
v-yueyunzh-msft
Community Support
3 years agoHi , CliffordAP
Im's sorry i'm not very knowledgable abnout the DMV.As searched, I think you can try add % in your sql .
LIKE 'w%'
For more information, you can refer to :
SQL LIKE Operator (w3schools.com)
And you can try to use dax use the CONTAINSSTRING() function:
EVALUATE
FILTER('$SYSTEM.TMSCHEMA_MEASURES',CONTAINSSTRING('$SYSTEM.TMSCHEMA_MEASURES'[Expression],"w"))
For more information, you can refer to :
CONTAINSSTRING function (DAX) - DAX | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly