Append result from two slicers as new table

[temp0rary]

Hi,

I have two tables with the same values and I need to create a new table based on filter on slicer of two tables.

Here is my two slicers

I want my new table look like this.

Value

AAA

BBB

BBB

CCC

DDD

I have tried this but It's not work

Test = UNION(VALUES(Table1[Value]), VALUES(Table2[Value]))

Thank you for any advice.

[amitchandak · Accepted solution]

@temp0rary , You can not create a calculated table using slicer values

Have a combined table

Test = distinct(UNION(distinct(Table1[Value]), distinct(Table2[Value])))

then create a measure and display it with the value from the Test 

countrows(filter(Test , Test [Values] in UNION(VALUES(Table1[Value]), VALUES(Table2[Value])) ))