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.
Hi All,
My data has column values as given below:
I need to calculate abandoned% which is total sum of all abandoned cases closed (1100) vs total cases closed (22600)
DimCallType.Filter | DimCalldisposition.Name | Cases closed |
Active | Abandoned | 200 |
Inactive | Abandoned | 100 |
Active | Answered | 3500 |
Active | Answered Closed | 3600 |
Inactive | Answered | 100 |
Expired | Abandoned | 100 |
Active | Abandoned | 200 |
Inactive | Abandoned | 100 |
Active | Answered | 3500 |
Active | Answered Closed | 3600 |
Inactive | Answered | 100 |
Expired | Abandoned | 100 |
Active | Abandoned | 200 |
Inactive | Abandoned | 100 |
Active | Answered | 3500 |
Active | Answered Closed | 3600 |
22600 |
HI @justalam
You can create a MEASURE on this pattern
See the attached file
Measure = DIVIDE ( CALCULATE ( SUM ( Table1[Cases closed] ), Table1[DimCalldisposition.Name] = "Abandoned" ), SUM ( Table1[Cases closed] ) )
How do I get the sum of [DimCalldisposition.Name]='Abandoned'?
Can you help me with this one?
We have a measure
Phone Response Rates = DIVIDE(CALCULATE(SUM(Consumer_Cube[Total Surveys])),CALCULATE(SUM(Consumer_Cube[Eligible])))
Eligible is a calculated column =
Eligible = If(Consumer_Cube[DimMSVoiceDisposition.Survey Disposition Filter]="No Filter",Consumer_Cube[Cases Closed - by First Closed Date],0)
We need another measure which is eligible % which should be sum of cases closed vs eligible
Mathematically calculated as sum of Eligible/sum of cases closed *100
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 |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |