Forum Discussion
Count with slicers from 2 tables
Table A Table B Product code Product code SAP Id Category A Brand Category B Category C I have above 2 tables. Both tables are linked via a one-to-one rel...
bhanu_gautam
Super User
Super UserTR_Belgium , First create a combined table either by using Merge in Power Query or by DAX
Go to model new table
CombinedTable =
NATURALINNERJOIN(
SELECTCOLUMNS(TableA, "Product code", TableA[Product code], "SAP Id", TableA[SAP Id], "Brand", TableA[Brand]),
SELECTCOLUMNS(TableB, "Product code", TableB[Product code], "Category A", TableB[Category A], "Category B", TableB[Category B], "Category C", TableB[Category C])
Then create measure
SAPIdCount = COUNTROWS(CombinedTable)
)
Thanks for the answer, would you know if it is also possible to have a solution without merging tables?