Showing values for missing attribute

Hello!
I’m pretty new to Quicksight, so I can’t figure out how to display only rows within a table that DO NOT have a specific attribute.

For example:
I want to see which IDs do not have a specific KPI included.
I want to filter for the KPI, and then it is supposed to show me a table with all IDs that do NOT have that KPI included. How does it work?
Thank you.

You can use the Exclude option on the filter
or at calculated filed use <> symbol which means “Not equal”

1 Like