Forum Discussion

camruny's avatar
camruny
New Member
10 years ago
Solved

Counting Strings with Wildcard

I have a table that has a list of URLs and I would like to create a count of all of the ones that end in .com, .org, .gov etc.  How can I write a formula that will do this?
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi camruny,

    Adding to other post, you can simply create a measure using CALCULATE and COUNTROWS functions to create a count of all of the ones that end in .com, .org, .gov . Here is an example for your reference.




    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi camruny,

Adding to other post, you can simply create a measure using CALCULATE and COUNTROWS functions to create a count of all of the ones that end in .com, .org, .gov . Here is an example for your reference.




Thanks,
Lydia Zhang

camruny's avatar
camruny
New Member
10 years ago

Thank you!  This is exactly what I was looking for!