Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DaliborBoldis
Frequent Visitor

Google Analytics count rows that contain specific char

Hello there!

 

I need help understanding how to properly count all rows in a table that contains the specific character.

 

A little bit more details - we're using Google Analytics to get data from our website. Upon selecting a particular town (which is a column I added with Query editor by using "Column from example") I am presented with a list of pages (without HostName dimension) for that town on my table and with other details on other visuals. This is perfect.

 

What I am struggling to understand is how to count rows in that table, so that I know how many pages are there for that particular town that I select?

 

I tried using this formula:

 

TotalPages = CALCULATE( COUNT('TPH'[Page]), 'TPH'[Page] = "-" ) And this does not work.

 

This means that I want to count all pages that contain "-" character only for any town that I filter my reports with.

 

Any help would be awesome! Thanks!

2 REPLIES 2
amitchandak
Super User
Super User

@DaliborBoldis , Try

TotalPages = CALCULATE( COUNT('TPH'[Page]),  CONTAINSSTRING('TPH'[Page],"-") )

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
harshnathani
Community Champion
Community Champion

Hi @DaliborBoldis .

 

 

Try this measure

 

TotalPages =
COUNTROWS (
    FILTER (
        'TPH'[Page],
        CONTAINSSTRING (
            'TPH'[Page],
            "-"
        )
    )
)

 

 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.