Forum Discussion

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Handled % overall

I have a table with Ticket number,Country, Month & HC. I have to calulate the handled %  Formula = total ticket/ Avg( HC). I am getting issue when i need to find the overall for a collection of mon...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    My bad.  I must have got distracted and didn't finish the measure.  Only got the numerators.  Please try this updated expression.

     

    Avg Monthly Handled =
VAR __summary =
    ADDCOLUMNS (
        SUMMARIZE ( Table, Table[Country], Table[Month] ),
        "@count", CALCULATE ( COUNTROWS ( Table ) ),
        "@avg", CALCULATE ( AVERAGE ( Table[HC] ) )
    )
RETURN
    AVERAGEX ( __summary, DIVIDE ( [@count], [@avg] ) )

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Please try this expression, replacing Table with your actual table name

 

Avg Monthly Handled =
VAR __summary =
    ADDCOLUMNS (
        SUMMARIZE ( Table, Table[Country], Table[Month] ),
        "@count", CALCULATE ( COUNTROWS ( Table ) )
    )
RETURN
    AVERAGEX ( __summary, [@count] )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • unnijoy's avatar
    unnijoy
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    mahoneypat 

     

    in the measure that you gave i am not able to understand wer we are calculation the total Ticket count and Avg of HC. Bec when i use the formula it is not giving me corect valuse, Can you please check and confirm.

    • mahoneypat's avatar
      mahoneypat
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      My bad.  I must have got distracted and didn't finish the measure.  Only got the numerators.  Please try this updated expression.

       

      Avg Monthly Handled =
VAR __summary =
    ADDCOLUMNS (
        SUMMARIZE ( Table, Table[Country], Table[Month] ),
        "@count", CALCULATE ( COUNTROWS ( Table ) ),
        "@avg", CALCULATE ( AVERAGE ( Table[HC] ) )
    )
RETURN
    AVERAGEX ( __summary, DIVIDE ( [@count], [@avg] ) )

       

      If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

      Regards,

      Pat