Forum Discussion

RevOps608's avatar
RevOps608
Helper II
2 years ago
Solved

Using a column with multiple duplicates in matrix values

I have a table ('Opportunities), each opportunity is unique but I have 'Opp Owners' (i.e. salespeople) that have multiple opportunities apiece. If I drag in Opp Id's in Rows I would like to drag in 'Opp Owners' into Values to see who owns those opportunities. I cant because Implicit measures is turned off. How do I turn a column with duplicates into a explicit measure that I can use in the values field. In the picture I'm using Opp Owner (Values) = DISTINCTCOUNT(Opportunity[Opp Owner]). But I dont want the number. I want the name.

Thank you