Count text values that start https://

[Anonymous]

Hi Experts

How would you amend the following measure to count items in a column that start https://

Website Visits =

VAR Result = COUNTROWS(FILTER(BIvw_ResponseTapCalls,

BIvw_ResponseTapCalls[crimson_talktime] >= 1 ))

RETURN

IF ( Result = BLANK (), 0, Result )

[mahoneypat · Accepted solution]

Please try this expression

Website Visits =
VAR Result =
    COUNTROWS (
        FILTER (
            FILTER ( BIvw_ResponseTapCalls, BIvw_ResponseTapCalls[crimson_talktime] >= 1 ),
            LEFT ( BIvw_ResponseTapCalls[URLcolumn], 8 ) = "https://"
        )
    )
RETURN
    Result + 0

Pat

[Anonymous]

Hi Pat - if i no longer needed the >1 filter step then

Website Visits =
VAR Result =
    COUNTROWS (
        FILTER (
              LEFT ( BIvw_ResponseTapCalls[URLcolumn], 8 ) = "https://"
        )
    )
RETURN
    Result + 0

Would be correct???