Count % of using a mix of distict and non-distinct values

[CauseAndEffect]

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.

[Anonymous]

@CauseAndEffect try below measure and check if it works.

Measure = CALCULATE(COUNT('Table'[ID]),ALLEXCEPT('Table','Table'[ID]))

[CauseAndEffect]

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.

Can't describe in DAX (reason why i write here) But something like:

IF SerivceID IS Distict -> Solved by reporter / opened by reporter 

Output: % of Service cases that are opened and solved by reporter.

[CauseAndEffect]

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]))