Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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])) ))
@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])) ))
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |