Hi Susan, Pls look into this article. It may solve this issue.https://docs.looker.com/reference/field-reference/measure-type-reference#average_distinctIf not, pls elaborate more about the issue. You have written distinct count of id however you want ...