I need to sum words from different tables. Example:
I need to obtain this result: Total: 9. FCO=4, MSE=3, MCA=2.
Could you help me please?
Go to Solution.
Based on my test, you can firstly use the formula below to create a new union table.
SELECTCOLUMNS ( Table1, "NewColumn", Table1[Column Name] ),
SELECTCOLUMNS ( Table2, "NewColumn", Table2[Column Name] )
Then you should be able to show the "NewColumn" and [Count of NewColumn] from the new created table on the Table visual to get your expected result.
View solution in original post
Using Query Editor, you can append data from both tables into a single one and then write this measure.
Hope this helps.
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.