Excluding values ​​from another table with UX view

[Slayer]

Good day. There was a problem when creating a slice based on the results of a condition from another sheet. It is required to display in UX only those values ​​that are not repeated in the first sheet. Please tell me how can I do this?

[Rafael_ANEIC-PY · Accepted solution]

Hello, If i understand correctly you want to display the values from table A that are not present in table B, if this is correct, It can be done using list substraction or expressions like intersect() or in(), for example, considering the slice condition resides in table A:

ISBLANK(
        INTERSECT(
                 LIST([filterColumnA]),
                 Table B[filterColumnB]
                  )
)

 
You could replace the column and table names and give that a try, OR if you could share some info about your app structure I could attempt to provide an exact solution, in any case, let me know if this helps you.

[Rafael_ANEIC-PY · Accepted solution]

Hello, If i understand correctly you want to display the values from table A that are not present in table B, if this is correct, It can be done using list substraction or expressions like intersect() or in(), for example, considering the slice condition resides in table A:

ISBLANK(
        INTERSECT(
                 LIST([filterColumnA]),
                 Table B[filterColumnB]
                  )
)

 
You could replace the column and table names and give that a try, OR if you could share some info about your app structure I could attempt to provide an exact solution, in any case, let me know if this helps you.

[Slayer]

Hello, Here it is displayed at the moment only duplicate values. You want to display values ​​that are different from those in the ~history table
ISBLANK(
INTERSECT(
LIST([Location]),
~history[Location]
)
)

[Rafael_ANEIC-PY · Accepted solution]

INTERSECT() only returns the values that are common to both lists, so it should return a blank value when there's no match, so ISBLANK() should return TRUE for that row, maybe try replacing the first argument of INTERSECT() with this:

LIST([_THISROW].[Location])