Forum Discussion
Solved
EXCEPT for columns
Hi, I have two tables, t1 and t2, each of them containing multiple, partially different, columns. One of the columns, let's call it A, exists in both tables, but the values of the column A are no...
You can create a measure along the lines of:
A only in t1 = COUNTROWS ( EXCEPT ( VALUES ( 'Table 1'[A] ), VALUES ( 'Table 2'[A] ) ) )(The function VALUES returns a table of unique values-including blank rows- of the column within)
Then create a table visual with the field from Table 1[A], add the measure to the filter pane and set the value to = 1
If you need a physical table, use :
A only in t1 = EXCEPT ( VALUES ( 'Table 1'[A] ), VALUES ( 'Table 2'[A] ) )
You can create a measure along the lines of:
A only in t1 =
COUNTROWS ( EXCEPT ( VALUES ( 'Table 1'[A] ), VALUES ( 'Table 2'[A] ) ) )
(The function VALUES returns a table of unique values-including blank rows- of the column within)
Then create a table visual with the field from Table 1[A], add the measure to the filter pane and set the value to = 1
If you need a physical table, use :
A only in t1 =
EXCEPT ( VALUES ( 'Table 1'[A] ), VALUES ( 'Table 2'[A] ) )