Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I've been experimenting with DAX wild cards but not getting the results I expected.
Here's a sample of the data I'm using:
CALCULATEI wondered whether I could, in CALCULATE statements, use just part of the "Product" text by using wildcards. I've created the following Measures:
, but I can't get these to work, for example:
These 2 work fine - no wildcards:
Hi, here are some possible strategies for solving your problem:
https://www.sqlbi.com/articles/from-sql-to-dax-string-comparison/
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |