Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |