Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Filter Filtered Data

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 ...
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    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

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

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's avatar
Anonymous
Not applicable
9 years ago

This worked perfectly.  Thank you for your time and assistance.