Forum Discussion

key_master_95's avatar
key_master_95
Frequent Visitor
3 years ago
Solved

Create a table with filter with contain

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!

Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    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.

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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.