Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am writing a measure to count all records containing "director" within a job title collumn. However they all vary. Instead of using "IN", what can I use to pick up anything containing "director"?
Example of my measure below.
Thanks in advance!
Solved! Go to Solution.
I have been able to do it with the below! 🙂
Hey man,
Maybe you could use a regular expression. This could help: https://community.powerbi.com/t5/Desktop/Filtering-a-text-column-for-a-specific-pattern/m-p/540794
Best,
Milan
Unfortunately my knowledge is quite basic and i am not familiar with custom functions or R Script :(, but thanks!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |