Forum Discussion
Table visual with data from 2 different data table only showing common data
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?this seems created another problem...
it cannot be refreshed with an error like this "We cannot refresh this dataset because the dataset contains calculated tables or calculated columns based on data from a Single Sign-on (SSO)-enabled Direct Query data source. Please configure the dataset to use an explicit connection with granular access control to access this data source and then try again."
any other option?See the article below for more details.
Are you able to access the underlying data source of 'Table A'[Case ID]? If so, you could import it into your model and union it with 'Table B'[Case ID], forming a master Case ID table.
