Forum Discussion

egsiegel's avatar
egsiegel
Frequent Visitor
5 years ago
Solved

Calculation on Measure Totals

I have a measure that calulates the number of minutes "worked" by an call center agent.  It takes the number of phone calls * the expected duration of a phone call and the number of emails handled * ...
  • v-robertq-msft's avatar
    5 years ago

    Hi, egsiegel 

    According to your description and example, I can understand roughly your logic and the output you want to get, you can try this measure to replace the calculated column I created before to calculate the percent:

    To test the function of this measure, I changed the sample data to make them within the same date, like this:

     

    agent percetage1 =
    
    var _valueofCall=
    
    CALCULATE(SUM(Merge1[Count]),FILTER(ALL(Merge1),[skill]="Call"&&[AgentName]=MAX('Merge1'[AgentName])))
    
    var _valueofEmail=
    
    CALCULATE(SUM(Merge1[Count]),FILTER(ALL(Merge1),[skill]="Email"&&[AgentName]=MAX('Merge1'[AgentName])))
    
    var _valueoflogintime=
    
    CALCULATE(SUM(Merge1[Table (2).Logintime]),FILTER(ALL(Merge1),[AgentName]=MAX('Merge1'[AgentName])))
    
    return
    
    DIVIDE(_valueofCall*5+_valueofEmail*8,_valueoflogintime)

     

    Then you can create a table chart and place it like this:

     

    And I guess this can be what you want.

    You can download my test pbix file here

     

    If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

    How to Get Your Question Answered Quickly 

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.