Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I can run a query with a where clause that is equal to or not equal to something like this:
But what I would like is a query that can evaluate a string CONTAINED in the expression (In SQL they use a 'LIKE' expression).
I looked at a lot of examples, but the documentation about the features for these queries are very limited and none refer to this kind of query.
I'm going for something like:
Any help would be greatly appreciated.
Hi , @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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |