Forum Discussion
Table visual with data from 2 different data table only showing common data
i created a table visual getting data from 2 different data tables but it only shows data which is common in both table. Anybody have some idea why and how to resolve? table A is a main table wit...
One approach is to create a DAX calculated table consisting of all Case ID values in the two tables. Example:
Case ID Master =
DISTINCT (
UNION ( DISTINCT ( 'Table A'[Case ID] ), DISTINCT ( 'Table B'[Case ID] ) )
)
The table 'Case ID Master' should have a relationship with 'Table A' and 'Table B'. Use 'Case ID Master'[Case ID] in the visual.
that works~
do you know is that beacuse my Table A was imported from an separate dataset causing such problem? or sth else?
any idea why such behavior?