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!: Power BI Cookbook Third Edition (Color)
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!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - August 2024
Check out the August 2024 Power BI update to learn about new features.
Fabric Community Update - August 2024
Find out what's new and trending in the Fabric Community.
