cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

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

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.

3 REPLIES 3
Anonymous
Not applicable

@CauseAndEffect try below measure and check if it works.

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

Helper I

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.
Helper I

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.