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 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.