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.
Count = CALCULATE(count('TableName'[Transaction]), filter('TableName', 'TableName'[TransactionIDString] = "djyv" ) )
Hi,
Please could you tell me how to change the above code to search for a wildcard? I've tried replacing "djyv" with "*djyv*" but that doesn't work.
I have lots of other conditions in the real formula so would like to keep the current formula structure if possible!
Thanks,
CM
Solved! Go to Solution.
Hi @CloudMonkey ,
You could have a reference of this similar thread which has been solved.
If you still need help, please share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi @CloudMonkey ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample and your desired output so that we could understand your scenario better and get the solution quickly.
Best Regards,
Cherry
Hi @CloudMonkey ,
You could have a reference of this similar thread which has been solved.
If you still need help, please share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi
I am unsure how to do this directly in a measure. However, one way to get around this might be to include a column that uses "SEARCH" to look for the partial string and returns a true or false flag. You could then use this to drive your measure?
Thanks
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |