Using a column with multiple duplicates in matrix values

RevOps608 — Tue, 12 Dec 2023 19:14:11 GMT

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

Re: Using a column with multiple duplicates in matrix values

Greg_Deckler — Tue, 12 Dec 2023 19:19:05 GMT

RevOps608 Replace DISTINCTCOUNT with MAX

Re: Using a column with multiple duplicates in matrix values

RevOps608 — Tue, 12 Dec 2023 19:23:35 GMT

Thank you!

topic Re: Using a column with multiple duplicates in matrix values in DAX Commands and Tips

Using a column with multiple duplicates in matrix values

Re: Using a column with multiple duplicates in matrix values

Re: Using a column with multiple duplicates in matrix values