I need to write a measure that gives me the distinct count of items in one table that do not appear in another table.
Table1 appears as follows:
Table2 appears as follows:
I want to write a measure that returns a result of 1 because ID 1003 in Table1 does not appear in Table2.
Any and all help would be greatly appreciated.
Go to Solution.
Also you can use this MEASURE
COUNTROWS ( EXCEPT ( VALUES ( Table1[ID] ), VALUES ( Table2[ID] ) ) )
View solution in original post
You could do this in 2 steps:
IsInTable2 = LOOKUPVALUE(Table2[ID],Table1[ID],Table1[ID])
NotInTable2 = COUNTBLANK(Table1[IsInTable2])
Hope this helps
Thanks for the suggestion. I appreciate you taking the time to submit it.
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!