Forum Discussion
DAX - EXCEPT
Hi, I would like to get the Distinct value from 2 tables ( After tableA EXCEPT tableB) --> the result should be "A" However I would like to set a expression for TableA as All(TableA) T...
Anonymous , you need a new table
New table = except(all(TableA[Item]), distinct(TableB[Item]) )
other wise you need a common table to plot a measure
countrows(except(all(TableA[Item]), distinct(TableB[Item]) ) )
Anonymous
*Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Mahesh0016
Super User
Super UserAnonymous
*Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!