Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |