Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two tables that contain a few shared columns that I want to use as slicers to filter both sets of data at once. I do not wish to combine these tables as they are pretty different data and the are also separate API connections.
For the first shared column I tried to build a new table to use as a filter instead as so:
What am I missing? Is there a workaround or different method to do this?
Solved! Go to Solution.
Hello @trevordunham ,
You may need to create new table with unique values and use them in slicer to filter data (this may work as this is one of the way for this kind of similar situations)
Table can be created using below DAX:
SharedTable = UNION(DISTINCT('Table1'[Shared Column]), DISTINCT('Table2'[Shared Column]))
Then create a filter expression to filter data in the visuals using below DAX:
FilteredData =
FILTER(
'Table1',
'Table1'[Shared Column] IN VALUES(SharedTable[Shared Column])
)
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
I discovered an error in my original table, using my first table:
I discovered an error in my original table, using my first table:
Hello @trevordunham ,
You may need to create new table with unique values and use them in slicer to filter data (this may work as this is one of the way for this kind of similar situations)
Table can be created using below DAX:
SharedTable = UNION(DISTINCT('Table1'[Shared Column]), DISTINCT('Table2'[Shared Column]))
Then create a filter expression to filter data in the visuals using below DAX:
FilteredData =
FILTER(
'Table1',
'Table1'[Shared Column] IN VALUES(SharedTable[Shared Column])
)
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Thanks @Kishore_KVN
This does not seem to be working. Your suggested table is what I initially attempted but the filter expression does not make sense to me. This only filters table 1, I need column that works for both tables. I also am getting the following error when attemptint to create your filter expression: "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
User | Count |
---|---|
99 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |