Forum Discussion
Anonymous
3 years agoNot applicable
Dax Comparing Two Columns From Different Tables Returning Incorrect Result
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...
- 3 years ago
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] ) ) ) )
wdx223_Daniel
Community Champion
3 years agohow the 1441 comes?
filter by date of 2023 Feb, the different count is 1463