As you can see in your screenshot there are multiple id values for a value of the other dimension. For example 'sad' has id's 5 and 6. Therefore id, which is really =only(id), returns null. Try max(id) instead. Or min(id) or avg(id). Dunno what suits you best.