Show values that are Filtered out on all pages

[kenneth_mejia]

Is there a way to show all Filtered out values in a Table visual?

I have a PBIX report with multiple pages and I have to exlude some sites.

Now, I would like to diplay all those "Site is not [Site A], [Site B], [Site C], [Site D] in a visual table as shown below.

              Excluded Sites

Sites

[Site A]

[Site B]

[Site C]

[Site D]

[v-joesh-msft · Accepted solution]

Hi @kenneth_mejia ,

To achieve the effect you want, you need to first create a calculated table:

ShowFiltersTable = DISTINCT('Table'[Name])

Then create a measure in the original table:

showFilterStatus =
IF (
    SELECTEDVALUE ( 'ShowFiltersTable'[Name] )
        IN EXCEPT ( ALL ( 'Table'[Name] ), FILTERS ( 'Table'[Name] ) ),
    1,
    BLANK ()
)

The result is as follows:

Here is a demo, please try it:

 https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EQm4RS-3SIxOiWfomU...

Best Regards,

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

[kenneth_mejia]

@v-joesh-msft Thanks. It works!