Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am new and apologize if this has been discussed prior, but I need to find away to filter data using data from a prior filtered result.
My table looks like this:
Name Skill
User 1 A,B,C
User 2 B,C,D
User 3 C,D,E
User 4 A,B,E
Using a filter or slicer, I would like to be able to find all of the users with Skill C then filter the result of that to find the Users with Skill A. Is this easy, difficult, possible?
Thank you in advance for your time and assisstance.
Solved! Go to Solution.
@Anonymous,
Create two tables(Slicer1 and Slicer2) which will be used in your slicer. Then create two measure in your original table.
Slicer1 =
var selecteditem = MAX(Slicer1[Slicer])
return IF(HASONEFILTER(Slicer1[Slicer]),IF(ISERROR(SEARCH(selecteditem,MAX(Table2[Skill]))),0,1),1)
Slicer2 =
var selecteditem = MAX(Slicer2[Slicer])
return IF(HASONEFILTER(Slicer2[Slicer]),IF(ISERROR(SEARCH(selecteditem,MAX(Table2[Skill]))),0,1),1)
Then add those two measures into visual filter.
Regards,
Charlie Liao
@Anonymous,
Create two tables(Slicer1 and Slicer2) which will be used in your slicer. Then create two measure in your original table.
Slicer1 =
var selecteditem = MAX(Slicer1[Slicer])
return IF(HASONEFILTER(Slicer1[Slicer]),IF(ISERROR(SEARCH(selecteditem,MAX(Table2[Skill]))),0,1),1)
Slicer2 =
var selecteditem = MAX(Slicer2[Slicer])
return IF(HASONEFILTER(Slicer2[Slicer]),IF(ISERROR(SEARCH(selecteditem,MAX(Table2[Skill]))),0,1),1)
Then add those two measures into visual filter.
Regards,
Charlie Liao
This worked perfectly. Thank you for your time and assistance.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |