In DAX, it doesn't have function perform as wildcards. The DAX provided in my previous reply is based on your sample data, as you mentioned it will not work, can you please share the sample to clarify which scenario doesn't work?
Best Regards, Qiuyun Yu
Community Support Team _ Qiuyun Yu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I want to count the target - URL's, if they exist in the Libary-table. Please see the image below:
I thought I can handle this with a new table and the summarize-function, but I'm stuck. I don't really care, if I have to add a new column or a new table or just a measure. The main part is, that this function has to work 🙂