PowerBI pie chart exclude data points filter

[kravhowe]

Hello everyone, 

using a pie chart the user can exclude certain data point by clicking right and confirm "exclude". Clicking right adds a filter to the visual of type "exclude x = "abc"". 

Now I want to have a table which shows all the exlcuded entries. So far I was unable to achieve this. I tried to work with filters and use NOT IN, or work with a reference table and calculate the differences. No success. 

I'd really appreciate your advice. Thanks. 

[amitchandak]

@kravhowe , Try with a measure like this

countx(filter(all(Table), not(table[X] in values(table[X]))),table[X])

[kravhowe]

Thanks for your advice @amitchandak 

The DAX expression is correct, but still gives me an empty result. 

Greetings

[Anonymous]

@kravhowe 
Please refer to the method:
https://www.skillslogic.com/blog/dashboards-data-warehousing/power-bi-how-to-show-rows-excluded-by-s...

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

[kravhowe]

Thanks for your reply @Anonymous 

Still I couldn't find a solution yet. I understand the logic behind the proposed article. As already mentioned, I thought of something quite similar. 

The thing is that EXCEPT(ALL('table'), 'table') does not seem to work here. However, I dont want to rule out any mistake on my side. 

It seem as if clicking "right" on a data point in the pie chart and confirm exclude is not the same as using a slicer. The problem can easily be reproduced.