Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

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:

 

IDOpen groupClose groupFirst Solution
11233Daves teamDaves team1
11233Daves teamDaves team1
11234Daves teamDaves team1

 

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

 

Sorry for being terrible at explaining:

 

See this table:

Service IDReporterSolverSolved by reporter
AJ123POLERK 
AJ124ERKERK1
AJ125POLPOL1
AJ126ERKPOL 
AJ128ERKERK1
AJ128ERKERK1
AJ128ERKERK1

 

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.

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

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors