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)
| TableA |
| Item |
| A |
| A |
| B |
| C |
| C |
| D |
| TableB | |
| Item | Date |
| B | 1/1/2023 |
| C | 1/1/2023 |
| C | 1/1/2023 |
| C | 1/1/2023 |
| D | 1/1/2023 |
Here is how I try but not working
EXCEPT(
CACULATE(VALUES(TableA[Item]), ALL(TableA),
VALUES(TableB[Item]))
May I seek some advise?
Thanks so much
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 !!
2 Replies
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 !!