Creating one report with two joined tables and other report with only one table

[SubhaSakhinala]

Data: I have two tables. Table A, Table B

I need to create 3 reports.

1. With only data in Table A

2. With only data in Table B

3. Data in Table A but not in Table B (for this we need to join tables)

Question

Here to obtain first 2 reports I need individual tables (which are not joined) and for 3rd report, I need to join tables.

In this case I need to keep 2 tables and other 2 duplicate tables to join them and use it

Is there a better solution, instead of duplicating the tables?

[SubhaSakhinala · Accepted solution]

Table = var _new = EXCEPT(ALL(Table1[Name]),all(Table2[Name])) return filter(Table1, Table1[Name] in _new)

This worked.

[amitchandak]

@SubhaSakhinala , if both tables has the same number of columns and data type

a new table

C=  except(A,B)

Else create a column on the id column

C = distinct(except(distinct(Table[A]),distinct(Table[B])) )

then create measure like below or use below meausre as visual level filter and check for nonblank

countrows(filter(A, A[ID] in values(c[ID])))