How to create a Slice without duplicates

[Alberto68]

Good afternoon everyone! Could someone tell me how I can make a slice with unique values ​​from a table?...

[Izzat_Safrah]

Use virtual column in your table to found duplicates value in some columns

Example

In “Table_A” there column name [ITEM] have a duplicate value

Add virtual column name[Duplicate]

In app formula use this function

IFS(

MIN(SELECT(Table_A[_RowNumber],

[ITEM] = [_Thisrow].[ITEM] ))=[_RowNumber], “1” ,

ISBLANK(SELECT(Table_A[ITEM], [ITEM] = [_Thisrow].[ITEM])), “1”,

True, “duplicate” )

Now use this function in slice

[Duplicate]=“1”

[Alberto68]

Thank you very much for the solution

[Izzat_Safrah]

You are welcome.