cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
petra_miriam
Frequent Visitor

Lost in circular dep. with perctg

Hello

 

I'm pretty stucked with something what I want to highlight in a report about how employees handling tickets.

I want to show statistics for each employees (filtering individually) using card visual with information what is percentage of sev1 and sev2 he has resolved.

We have 4 ticket severity, from 1 to 4 (lowest). Ratio is:

 

Untitled.png

 

 

 

 

 

 

 

So, I dont want to show whole table with unnecessarily data like this:

Untitled2.png

 

 

 

I dont want show the count of sev1+sev2 (irrelevant) - it must be info about percentage of sev1 and sev2 (the summ or separatelly) between all ticket resolved by that employee.

 

Thank you in advance

 

Petra

 

 

 

 

1 ACCEPTED SOLUTION

Huh, I make it possible!

I don't know why was so hard to write this measure!?

Untitled.png

 

 

 

 

 

Ok, I'm begginer, recently started to learn  🙂 Thanks anyway!

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User IV
Super User IV

Can you just filter out Severity 2 and 3 from your visualization?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Unfortunatelly, the result is this:

Untitled3.png

 

 

 

 

His statistic is:

 

Untitled.png

 

 

 

So I need only one information: that he has resolved 95/416*100  sev1 tickets of all his tickets.

Very simple but...impossible for me.

 

p

 

 

Huh, I make it possible!

I don't know why was so hard to write this measure!?

Untitled.png

 

 

 

 

 

Ok, I'm begginer, recently started to learn  🙂 Thanks anyway!

View solution in original post

OK, just collapse your unwanted columns so that they disappear? Can you post some sample data and a screen shot or explanation of the fields filled into your visual?

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors