Forum Discussion

DaliborBoldis's avatar
DaliborBoldis
Frequent Visitor
6 years ago

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 fro...
COUNTROWS
DAX
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)