invalues()
1 Topic
NOT INVALUES is not working
I have two tables: SalesReps with Columns Name, Phone Jan Kowalski, 48123456789 and PhoneLogs with Columns Caller, RecipientNo, CallLength and some other columns I have relation between both tables: *:1 PhoneLogs[Caller] to SalesReps[Name] Now I want to calculate the length of all calls that were not made to other Sales representatives (RecipientNo does not exist in SalesReps[Phone] and display it in table visual (not exact formatting but You will get an idea): _callLenght = calculate( sumx(PhoneLogs, PhoneLogs[CallLength]), FILTER( PhoneLogs, NOT PhoneLogs[RecipientNo] IN VALUES(SalesReps[Phone]) ) ) But this measure still calculates sum of length of all calls... Where is an error in my way of thinking? Thanks in advance!Solved2.6KViews0likes17Comments