Help with DAX for slicers - multiple selections and default value

Question

Hello everyone!&nbsp;Can you help me? I’m new to PowerBI&nbsp;I have a table ("MockupTest")&nbsp;that has names and the primary/secondary skills of those people, something like this:&nbsp;MockupTest&nbsp; &nbsp; &nbsp; Name&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; Primary Skills&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; Secondary Skills&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IrinaA, B, CG, H, I, EAmyD, E, FI, C, HBobD, B, CA, E&nbsp;I'm trying to make a single slicer to filter both columns ("Primary Skills" and "Secondary Skills), where you can select each of the skills (for example, just "A" or "B"). Right now, I created a new table called "Skills_metric" where I added the column "Skills" and each row has only one skill, like:&nbsp;Skills_metric&nbsp; &nbsp; Skills&nbsp; &nbsp; &nbsp;ABC...&nbsp;Inside this table, I created a metric with this code:filterSkills =&nbsp;VAR a =&nbsp;IF (CONTAINSSTRING(VALUES ('MockupTest'[Primary Skills]), VALUES ('Skills_metric'[Skill]))|| CONTAINSSTRING(VALUES ( 'MockupTest'[Secondary Skills] ), VALUES ( 'Skills_metric'[Skill])),1, 0)RETURN&nbsp;IF ( ISFILTERED ( 'Skills_metric'[Skill] ), a, 0 )&nbsp;Then used the column "Skills" in the slicer and put the metric "filterSkills" inside the filters for the "MockupTest" table.&nbsp;&nbsp;This is working fine with single selections but doesn't allow me to pick multiple selections in the slicer. Also, the default value is no row at all (just the headers appear if you don’t select any skill in the slicer).&nbsp;Can someone correct my code or give me a new one? The expected result would be something like this:&nbsp;Selected: "A" and "B"&nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;Primary Skills&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; Secundary Skills&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;IrinaA, B, CG, H, I, EBobD, B, CA, E&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;MG06&nbsp;
You can refer to the following measure
Measure = var a=COUNTROWS(FILTER(VALUES('Table (2)'[Skills]),CONTAINSSTRING(SELECTEDVALUE('Table'[Primary Skills]),[Skills])))
var b=COUNTROWS(FILTER(VALUES('Table (2)'[Skills]),CONTAINSSTRING(SELECTEDVALUE('Table'[Secondary Skills]),[Skills])))
return IF(OR(a&gt;0,b&gt;0),1,0)
Then put the measure to the visual filter

Output

&nbsp;
Best Regards!
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
&nbsp;

Forum Discussion

Help with DAX for slicers - multiple selections and default value

2 Replies

Related content

Selected slicer

button slicer single select allows for multiple selections

Slicer default selection

select multiple boxes in slicer

Single select slicer

Name	Primary Skills	Secondary Skills
Irina	A, B, C	G, H, I, E
Amy	D, E, F	I, C, H
Bob	D, B, C	A, E

Name	Primary Skills	Secundary Skills
Irina	A, B, C	G, H, I, E
Bob	D, B, C	A, E