Part 2 - return count of mathing 'Type B' values (for each 'Type A' value in the above resulting column):ДЄDDCOLUMNS(Part 1 expression),'Cnt of Matching Type B Values',COUNTROWS(CALCULATETABLE(DISTINCT(Table 2)ДЄDDCOLUMNS(INTERSECT(DISTINCT(Table1),DISTINCT(Table 3)),'Cnt of Matching Type B Values',COUNTROWS(CALCULATETABLE(DISTINCT(Table 2)ДЄgain, the second column in the resulting virtual table ('Cnt of Mathing Type B Values') populates accurate counts of matching 'Type B' values. INTERSECT(DISTINCT(Table1),DISTINCT(Table 3)) Part 1 - return single column table containing common 'Type A' values btw Tables 1 and 3: But, how might one go about returning the mathing 'Type B' values (text) as opposed to -in this example- a count thereof? an accurate count of 'Type B' values matching each 'Type A' value. Since ADDCOLUMNS() is an iterator, I am able to wrap the ADDCOLUMNS() expression argument in CALCULATETABLE which in turn is wrapped by an Iterator function (e.g. Note that Table 2 contains 'Type A' and 'Type B' values (so there is a granularity transition there.) Now I wish to generate an additional (extended) column using ADDCOLUMNS() to return all values of 'Type B' from Table 2, which match the 'Type A' values returned in the first column via INTERSECT() statement. I used an INTERSECT() to generate aВ single column table that is aВ return of distinct values of 'Type A' that are common between Table 1 and Table 3.

I have a question for the Community as follows:

Igor pro 7 add column