Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have two tables each having two columns. One of them being facility which is common to both. The other one is # of entries and # of exits. I am trying to merge this into a single table.
Facility | # of entries |
Facility | # of exits |
The # of entries and exits are values from the same column with different filters and aggregation types. Please help. I need the resulting table to look like this.
Facility | # of entries | # of exits |
Solved! Go to Solution.
You Measure are coming from the same column with filter, are you using the visual level filter to display those. If yes then use measure filter
example
# count = calculate(count(table[Col1]),table[Col2] ="ABC")
# count = calculate(count(table[Col1]),table[Col2] ="DEF")
Create a common Facility dimension table and join with both of them.
Facility Dim = distinct(union(all(table1[Facility]),all(table2[Facility])))
Then use common dimesnion to get desired results.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
@amitchandak Thank you for the reply. I am trying to merge table VISUALS and not actual tables. If I am creating a new table, where would I do it, I am pulling data from SQL server. Kindly answer in detail if possible as I am a beginner here.
You Measure are coming from the same column with filter, are you using the visual level filter to display those. If yes then use measure filter
example
# count = calculate(count(table[Col1]),table[Col2] ="ABC")
# count = calculate(count(table[Col1]),table[Col2] ="DEF")
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |