Show active filters in created filter pane, exclude fixed filters?

[MCLHRSM]

Goodmorning,

I have created a filter pane which allows the users to filter the reports in an organized way:

To ensure that end users are not forgetting active filters, I would like to display the number of active filters like this:

The logic of the measure is as follows:

var Employer = IF(ISFILTERED(Dim_Resources[Employer]), 1, 0)

var BusinessLine= IF(ISFILTERED(Dim_Resources[BusinessLine]), 1, 0)

...
Return Employer + BusinessLine +...

The issue I'm having is that I'm already filtering out some values in the standard filter pane on the right, which is hidden for the end users (filter on all pages, filter on this page etc.). For example:

Selections made here, are also counted in the measure above, creating confusing situations (e.g. no filters are selected by the end user in the created filter pane , but a value "1" is shown as a value is filtered out in the hidden filter pane).
The hidden filter pane is used to filter out some technical/general stuff that the end user is not aware of.

Is there a way to count the active filters, but only based on the used slicers in the created filter pane (and not counting any filtering in the hidden filter pane)? Duplicating the columns to use in the slicers is not something I want to do, as my data model is already quite large. Quite some filters are applied in the hidden filter pane and can change in the future, so a future proof measure which does not require modifications for every changes would be ideal.

Thank you in advance,

MCL

[Uzi2019]

Hi @MCLHRSM 

Try this video it show how to display the selected slicer values.

https://www.youtube.com/watch?v=M9sbRXuFtCM&t=26s

[MCLHRSM]

Thank you for the response. 

I do not want to show the filter values however, only show the number of used filters if any filters have been used in the created filter pane.

If values have been selected for the slicer "Employer" and "Business line", the count should show 2.
Even if 3 employers have been selected and 5 business lines, the number of active filters should be 2.