DAX - EXCEPT

[Anonymous]

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 

[amitchandak · Accepted solution]

@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]) ) )

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

[Mahesh0016 · Accepted solution]

@Anonymous 

*Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[amitchandak · Accepted solution]

@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]) ) )

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda