Calculating mutual occurrences

[EddP]

So I have a dataset that contains cookie data, detailing a path taken by a customer until their purchase has been completed.

E.g.

Order id (Key)	Pathtaken (String)
Order1	website1 -> direct -> website2 -> direct
Order2	website2 -> direct -> website2 -> direct
Order3	website3 -> direct -> website2 -> direct
Order4	website1 -> direct -> website3 -> direct
Order5	website1 -> direct -> website1 -> direct
Order6	website1 -> direct -> website2 -> direct

*With the above exampe, when website 1 and website 2 are selected the expected output would be 2, as website 1 and website 2 appear in 2 pathtaken together*

This path is broken up to different levels in the dataset, I am interested in level 4, which in the above example would be website1 and website2. I’m trying to count the number of times website1 and website2 appear together over all paths in the dataset.

I’ve duplicated the original table to make table2 and removed all columns apart from orderID and Level4 (for the name of the website). I’ve then used splicers to allow the user to choose 2 Level4 website addresses. I’ve then pulled that into a measure that turns the selection into a string (stringerT4 and Stringert4_second). This works fine when searching for the individual selections. But when I make the if statement to calculate the number of paths they BOTH appear in, it doesn’t quite work. I’ve gone for the contains function, but it just spits out one of the individual results and I can’t understand why.

I have the below code, the aim is to count the number of paths that contain both the selections:

Mutual = IF (

CONTAINS(Table, Table[path],Table[StringerT4])

&& (

CONTAINS(Table2, Table2[path],Table2[StringerT4_Second])) ,

COUNT(Table[order_id]))

The code for the stringer measures:

StringerT4 = CONVERT(SELECTEDVALUE(Table1[level 4]),STRING)

Is there an issue with what I’ve done that’s causing it to behave this way? I’m not sure if there’s a better function or way to achieve what I want.

TIA

[Greg_Deckler]

@EddP Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[EddP]

@Greg_Deckler reworded slightly