If Values in column A are equal to any non blank values of Column B, return "1"

[Nad_PBI_21]

Dear All,

I am not sure this is feasible this way

I wish to find all the match between two columns by comparing each line of "Customer" to the entire column "RelatatedCust":

if any non blanks value from column "RelatedCust" is found in column "Customer" then return 1 in new column "Related Articles"

What I am triing to achieve overall is to find all related "Service":

By selcting one service (ex: "Ananas") you could see all the associated services from all the customer taking that specific service "Ananas"

If I can answer the above issue, I can then put a fitler in the new column "Related Articles"

I am happy if you have another way, 

Thanks a lot for your help

NAD

Link to the file: https://www.dropbox.com/s/u0n8heaxvgltz32/Articles%20Analysis%20-%20shared.pbix?dl=0

[Ahmedx · Accepted solution]

pls try this

Related Articles = 
VAR _t1 = MAX('SelectService'[Service])
VAR _tbl = SELECTCOLUMNS(FILTER(ALL(Data),'Data'[Service]=_t1),"dd",[Customer])
RETURN IF(INT(
MAX('Data'[Customer]) in _tbl) ,MAX('Data'[Customer]))

[Ahmedx · Accepted solution]

honestly, I didn't understand you.
My measure works without yours and it will show all the match. why obyadit her with your measure, I do not understand

[Nad_PBI_21 · Accepted solution]

@Ahmedx 

thank you very much, it works well!!

sorry for the confusion

[Ahmedx · Accepted solution]

pls try this

Related Articles = 
VAR _t1 = MAX('SelectService'[Service])
VAR _tbl = SELECTCOLUMNS(FILTER(ALL(Data),'Data'[Service]=_t1),"dd",[Customer])
RETURN IF(INT(
MAX('Data'[Customer]) in _tbl) ,MAX('Data'[Customer]))

[Nad_PBI_21]

Great it works !! thanks a lot @Ahmedx 

Would you see a way to merge my 2 meaures into one, the idea is to have a table that looks like this : where I could rank the "related articles" (ideally the columns of the mesure should not be visible

Thank you very much

Here are the 2 measures: 

Related Articles =

VAR _t1 = MAX('SelectService'[Service])

VAR _tbl = SELECTCOLUMNS(FILTER(ALL(Data),'Data'[Service]=_t1),"dd",[Customer])

RETURN IF(INT(

MAX('Data'[Customer]) in _tbl) ,MAX('Data'[Customer]))

RelatedCust =

VAR Sele = SELECTEDVALUE ( SelectService[Service] )

VAR Serv = SELECTEDVALUE (Data[Service])

VAR Cust = SELECTEDVALUE(Data[Customer])

RETURN

    IF (Serv = Sele, Cust, ""  )

[Ahmedx · Accepted solution]

honestly, I didn't understand you.
My measure works without yours and it will show all the match. why obyadit her with your measure, I do not understand

[Nad_PBI_21]

@Ahmedx 

Last questions and thank you for your time

- Would you see a way to have multi select from the slicer

- Could the measure works with filter on the page : exemple date: Year (when I tested it, seems that the results where a not right)

[Ahmedx · Accepted solution]

pls try this for multi select from the slicer

Related Articles = 
VAR _t1 = VALUES('SelectService'[Service])
VAR _tbl = SELECTCOLUMNS(FILTER(ALL(Data),'Data'[Service] in _t1),"dd",[Customer])
RETURN IF(INT(
MAX('Data'[Customer]) in _tbl) ,MAX('Data'[Customer]))

[Nad_PBI_21]

All good, thank you very much !

[Nad_PBI_21 · Accepted solution]

@Ahmedx 

thank you very much, it works well!!

sorry for the confusion