Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |