Hi, I have this dax function that is returning incorrect result for Feb 2023 when counting the number of barcodes that are not present in table 2 when comparing to table 1. Appreciate any help please.Count of Missing Barcodes = COUNTROWS(FILTER('Table 1', NOT('Table 1'[Barcode] IN VALUES('Table 2'[Barcode])))) Pbix file here⬇️https://drive.google.com/file/d/1fEw5ywUZL4PBGc9k7GzmLL8iGPcAoL1U/view?usp=share_link

Anonymous Is this what you're looking for? Count of Missing Barcodes = COUNTROWS ( EXCEPT ( VALUES ( 'DistProfile v1-3'[Barcode] ), CALCULATETABLE ( VALUES ( 'DASHBOARD_RESULTS_HIST (2)'[BARCODE] ), ALLEXCEPT ( AcceptanceCalendar, AcceptanceCalendar[Year] ) ) ) )

Dax Comparing Two Columns From Different Tables Returning Incorrect Result

Forum Discussion

Related content

Date Different return wrong value

Power Query: compare two tables, return all differences in each of multiple columns

Compare different tables

Comparing values between different tables

Compare two columns in different tables