Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Not sure how to describe what I'm looking to do so I'll show you examples of the tables I have and the output I'm trying to achieve.
I have tow tables (Opportunities and Milestones) that are connected by the OpportunityID Column.
The Opportunities table records each have a unique ID (OpportunityID)
The Milestones table represents child records of the Opportunities table.
Desired Output
I would like to be able to display # of Opportunties records based on the # of unique Workloads per Opportunities record. Like this:
I believe I need to add a new column (Unique Workloads pe Opportunity) but can't figure out the proper syntax.
Any help would be appreciated.
HI @festazen ,
Try adding new DAX measure in the table.
like
I hope this will help you.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |