Forum Discussion

justalam's avatar
justalam
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Help in calculating column value % over the total

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.Filte...
justalam's avatar
justalam
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

How do I get the sum of [DimCalldisposition.Name]='Abandoned'?

justalam's avatar
justalam
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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