IF with multiple Contains

Similar to the below, I'm trying to make an IF statement with Contains but I am trying to count the times 2 (or more) affiliates appear in a customers click path together.

IF CONTAINS WITH MULTIPLE VALUES

E.g.

Selection1= HUKD

Selection2= TCB

OrderID	Path_Taken
Order1	Step1 -> Step2 -> HUKD -> TCB
Order2	Step1 -> Step2 -> HUKD -> TCB
Order3	Step1 -> Step2 -> HUKD -> TCB
Order4	HUKD-> Step2 -> HUKD -> Step4
Order5	Step1 -> Step2 -> Step3 -> TCB

The count would equal 3 as they appear in the paths together 3 times.

Stringer Code:

StringerT4 =

CONVERT(SELECTEDVALUE(Steps_AffiliateOnly[taxonomy_4]),STRING)

Mutual counter Code:

Mutual =

IF(

AND(

CONTAINS(Steps_AffiliateOnly, Steps_AffiliateOnly[path_taken],Steps_AffiliateOnly[StringerT4]),(

CONTAINS('Steps_AffiliateOnly_2','Steps_AffiliateOnly_2'[path_taken],'Steps_AffiliateOnly_2'[StringerT4_Second])))

, COUNT(Steps_AffiliateOnly[order_id]))

Logically it makes sense to me, but the output is not what i'm expecting.

Thanks in advance for any help

Anonymous
Are you looking for something like this?

FilterMeasure = 
COUNTROWS ( 
    FILTER ( 
        Orders,
        VAR String = Orders[Path_Taken]
        VAR Items = SUBSTITUTE ( String, " -> ", "|" )
        VAR Length = COALESCE ( PATHLENGTH ( Items ), 1 )
        VAR T = GENERATESERIES ( 1, Length, 1 )
        RETURN
            ISEMPTY ( 
                EXCEPT ( 
                    VALUES ( Stations[Station] ) ,
                    SELECTCOLUMNS ( T, "@Station", PATHITEM ( Items, [Value] ) )
                )
            )
    )
)

Community 497.pbix28 KB

Forum Discussion

IF with multiple Contains

6 Replies

Related content

Measure 'Contains' multiple.

Contain Word

Counting distinct list against multiple contain strings

Visual calculation- Contain

IF CONTAINS WITH MULTIPLE VALUES