Create a contains value measure for multiple values in dax

[jnrezk]

Hi,
I am trying to make a measure that will allow me to get all the visitors to pages that contain any page as follows: /good-driving/,  /car/, and /car-insurance/. 

This was my attempt and it is not working:

Pre Sale Visitors =

CALCULATE(

    DISTINCTCOUNT('GA Online Performance'[fullVisitorId]),

    'GA Online Performance'[PagePath]

        IN { "%/good-driving/%" }, { "%/car/%" }, { "%/car-insurance%" }

)

[Samarth_18 · Accepted solution]

Hi @jnrezk ,

Please try below code:-

Pre Sale Visitors =
CALCULATE (
    DISTINCTCOUNT ( 'GA Online Performance'[fullVisitorId] ),
    CONTAINSSTRING ( 'GA Online Performance'[PagePath], "/good-driving/" )
        || CONTAINSSTRING ( 'GA Online Performance'[PagePath], "/car/" )
        || CONTAINSSTRING ( 'GA Online Performance'[PagePath], "/car-insurance" )
)

Thanks,

Samarth

[jnrezk]

awesome. Thanks for the quick answer 🙂