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.
Go to 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:
SELECTEDVALUE ( 'ShowFiltersTable'[Name] )
IN EXCEPT ( ALL ( 'Table'[Name] ), FILTERS ( 'Table'[Name] ) ),
The result is as follows:
Here is a demo, please try it:
Community Support Team _ JoeyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@v-joesh-msft Thanks. It works!
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!