Create a table with filter with contain

[key_master_95]

Hi, all!

I have column on the table with URLs. The column is called Page. 

I need to create calculated column or table where condition 

'Table'[Page] contain (I dont know how it implements this contain to PBI filter) "breed"

Here, I mean how to implement contain to the filter in context of whole column. I need that PBI shows me only filtered by pages that contained "breed" in URL and after that calculates sum of users that visited this page.

How to make filter and calculate I know, but how to specify contain in the filter here?

Thank you in advance!

[amitchandak · Accepted solution]

@key_master_95 , You can add a visual or page level filter that url contains breed

or you can have meausre

Countrows(filter(Table, containsstring(Table[URL],"breed") )

and use it in the visual with other columns.