Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Disconnected Slicer

Hi,   I have 3 tables which i created. The 'Staff Certification' table shows all the staffs that has certificates and their certificates. The 'Staff' table shows all the staffs in "the company". Wh...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Please refer to my pbix file to see if it helps you.

    Create measures.

    Measure = var _1= CONCATENATEX(VALUES(Disconnected[Certs]),Disconnected[Certs],",")
return
IF(ISFILTERED(Disconnected[Certs]),_1,BLANK())

     

    Measure 2 = var _1=MAX(Staff[Certification])
return
 IF(CONTAINSSTRING(_1,[Measure]),1,0)

    About multiple selections on  disconnected slicer, I don't have an idea yet.

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Sir,

 

I tried doing your method but it's not working. I think my problem lies when I use group by in power query to merge duplicated colum with another.

For Example,

JamesCRTP
James

OSCP

 to

James

CRTP, OSCP

 

Somehow, i think having the comma there disturbs the name of the item which makes it hard to use containstring function.

 

Thank you