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.
I have a table of item details, and a table of events, which are either good or bad (1 or 0). There is a one-to-many relationship between 'Details'[Item ID] and 'Events'[Item ID]
I'm trying to write measures that will rank each Item ID by Sum(Good/Bad), partitioned by the Item Owner, and an overall ranking.
Any filters on the visual/page should affect the ranking.
Details
Item ID | Owner |
101 | Dave |
102 | Jeff |
103 | Jeff |
104 | Jeff |
105 | Dave |
106 | Jeff |
Events:
Item ID | Good/Bad |
101 | 1 |
101 | 0 |
101 | 1 |
101 | 0 |
102 | 1 |
102 | 1 |
103 | 0 |
103 | 0 |
103 | 0 |
103 | 0 |
104 | 1 |
104 | 0 |
104 | 0 |
104 | 0 |
105 | 1 |
Desired Result:
Item ID | Owner | Count | Good | Rank Overall | Rank by Owner |
101 | Dave | 4 | 2 | 1 | 1 |
102 | Jeff | 2 | 2 | 1 | 1 |
103 | Jeff | 4 | 0 | 5 | 3 |
104 | Jeff | 4 | 1 | 3 | 2 |
105 | Dave | 1 | 1 | 3 | 2 |
Solved! Go to Solution.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |