Forum Discussion
RevOps608
2 years agoHelper II
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
RevOps608 Replace DISTINCTCOUNT with MAX
2 Replies
- Greg_DecklerCommunity Champion
RevOps608 Replace DISTINCTCOUNT with MAX
- RevOps608Helper II
Thank you!