Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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". While the 'Disconnected' table is a disconnected slicer table which gets all the certs from the 'Staff Certification' table.
Right now, my disconnected slicer is not working and i'm not sure why. I looked through other Power BI Forum here and i tried following their method but it's still not working.
I want it to be in a way that when i selected a cert in the disconnected slicer, the staffs with that slicer will show up and also when i select the blank option, those with no certification will show up. Lastly, is it possible for me to have multiple selections on my disconnected slicer?
This is the file that i have right now.
https://drive.google.com/drive/folders/14AVmY-g_T1VJfD2-7WcTT14R10lehmjD?usp=share_link
Thank you, I tried fixing this for a few days now and I'm really stuck. Appreciate all the help i can get.
Solved! Go to Solution.
Hi @Afiq_Danial ,
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.
Hi @Afiq_Danial ,
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.
@Afiq_Danial , You can use treatas to pass value of this independent slicer in a meausre
https://docs.microsoft.com/en-us/dax/treatas-function
refer how to use in
Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE
example
calculate(sum(Table[Value]), filter(Table,Table[Column] in values(Ind[column]) ) )
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,
James | CRTP |
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |