Displaying settings of filter based on Primary Filter on same table[column]

[Anonymous]

Hi All

I have a report that contains a slicer/filter (source: Extensions[Name]) that is used by department managers to select their team members. This filter affects all pages of the report.

Supplementary to this is a second slicer/filter (source: Extensions[Name]) that is used to show data specific to 1 or more team members on 2 of the report pages.

The normal process of creating a measure using If(ISFILTERED(Table[Column]),"All",CONCATENATEX(),... works until the second filter is used. The measure will return the details of the second filter, but obviously not the first (although on the slicer all the originally selected values are still selected). Is there any way to 'preserve' or identify this original selection?

[v-yuta-msft · Accepted solution]

@Anonymous ,

---

The normal process of creating a measure using If(ISFILTERED(Table[Column]),"All",CONCATENATEX(),... works until the second filter is used. The measure will return the details of the second filter, but obviously not the first (although on the slicer all the originally selected values are still selected). Is there any way to 'preserve' or identify this original selection?

---

Maybe HASONEFILTER() can be more clear, but what does "'preserve' or identify this original selection" mean? If you mean not to remove the first filter when you select the second slicer, then I would suggest you to make a category hierarchy, put the primary selection column to the first slicer and secondary selection column to the second slicer.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanx for responding Jimmy Tao

HASONEFILTER() would not work becuse there could be more than one.

Category hierarchy would not work because the values of both slicers are the same source.

However, returning to the report this morning, the filtering is working fine. I have 3 values selected in the first and 1 in the second filter/slicer. On the pages that the single filter should apply i am getting data filtered correctly AND all the other pages are still displaying data filtered by the 3 values.

I will mark your post as Accepted to close the post.