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.
Hey'all.
This is probably very easy but i cannot figure it out.
I have a sheet as follows:
ID | Open group | Close group | First Solution |
11233 | Daves team | Daves team | 1 |
11233 | Daves team | Daves team | 1 |
11234 | Daves team | Daves team | 1 |
Trying to figure out how i can count the solution rate for each group. In above case Daves group recieves 3 solutions while i only want his group to recieve 2 since the unique ID is what counts.
I cannot remove those values since they add other valuable information in other fields.
First solution column is a function that evaluates if opengroup = closegroup.
When i try to add a formula, the first solution is never counted in the context of ID, i always get a way higher % than should be possible.
Thankful for any tips.
@CauseAndEffect try below measure and check if it works.
Measure = CALCULATE(COUNT('Table'[ID]),ALLEXCEPT('Table','Table'[ID]))
Sorry for being terrible at explaining:
See this table:
Service ID | Reporter | Solver | Solved by reporter |
AJ123 | POL | ERK | |
AJ124 | ERK | ERK | 1 |
AJ125 | POL | POL | 1 |
AJ126 | ERK | POL | |
AJ128 | ERK | ERK | 1 |
AJ128 | ERK | ERK | 1 |
AJ128 | ERK | ERK | 1 |
I want to calculate the unique number of reports / unique number of solutions.
Hey! Tried the formula and the result is that all groups have the exact same value.
Should i implement this in a formula e.g: (Your measure is table[ID]
Solutionrate = calculate(count(Table[ID]) / count(table[Solution]))
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |