Forum Discussion
Single Cross Table Visualization for Multiple Data Tables
Anonymous , Create a common ID Table
ID = distinct(union(distinct(Table1[ID]),distinct(Table2[ID]) ))
Join with both tables
Now have measure like
n1 = sum(Table1[Number])
n2= sum(Table2[Number])
S1 = sum(Table1[Status])
n2= sum(Table2[Status])
Now you can have measures like
Count Matched =
Countx(Values(ID[ID]) , if([n1] = [n2], [ID], blank()) )
Count not Matched =
Countx(Values(ID[ID]) , if([n1] <> [n2], [ID], blank()) )
Status Matched =
Countx(Values(ID[ID]) , if([s1] = [s2], [ID], blank()) )
Status not Matched =
Countx(Values(ID[ID]) , if([s1] <> [s2], [ID], blank()) )
Hi amitchandak Thank you so much for your inputs!!
For Point 1 only we have to do the comparision between Table1 and Table2 based on Status column.
For Point 2, we have to find the count of missing data.
for example, data which is available in Table 1 but not in Table 2 ---- Then this missing data count for Table 2 need to find and display in cross table. Same goes for data which is available in Table 2 but not in Table 1--- this will be missing data for Table 1.
This data can be calculated as you have explained but still I have a concern on how to display this data in cross table. Because I have a 100+ entities like A,B,C.... etc having 2 tables. So i have to display it in below format.
| Table Name | Status Mismatch Count | Table 1 Missing Data Count | Table 2 Missing Data Count |
| A | 2 | 2 | 1 |
| B | |||
| C |