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.
@RevOps608 Replace DISTINCTCOUNT with MAX
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@RevOps608 Replace DISTINCTCOUNT with MAX
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
