Forum Discussion
One column has unique values but comparing based on column with duplicate values
In PowerBI desktop, I am working on finding unique ID numbers that do not have production plans. There are two different tables being referenced, one with production data by unique ID. The other ...
amitchandak
Super User
Super Userjhearn123 , Based on what I got try measure like
CALCULATE(DISTINCTCOUNT('ProductionTable'[Unique ID]),FILTER('ProductionTable', 'ProductionTable'[Material ID] = EARLIER('MaterialTable'[Material ID])))
amitchandak unfortunately that does not work as the 'ProductionTable' does not contain the value MaterialID. The relationship between the two tables is the UniqueID. But multiple UniqueIDs can use a single MaterialID, so need to eliminate MaterialIDs that have any UniqueIDs in 'ProductionTable'